Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Link Pop-up On Cell Select To Cell


I'm hoping to hover my mouse over a cell to display text as popup. This text is linked to a cell and is dynamic.

I'm only wanting this feature to display info (in the popup) not link to a website

Currently I've dodged my way around the issue by using a hyperlink for the sole purpose of taking advantage of its hover popup feature.

The problem is that a hyperlink popup is limited to 255 characters so i can't display much text.

Is there is any VBA code or add-in's that take advantage of the mouse cursor position to display a text popup?

Kind of like the Comment feature but for dynamic use.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Link To Workbook Pop Up Box
I have a macro that works across 2 workbooks. In the middle of the macro, a message box pops up "This workbook contains links to other data sources" and I need to select yes or no. This is because I am using a vlookup. Is there a code that I can put in to the macro to select Yes to this box and therefore not stop the macro half way through??

View Replies!   View Related
Macro To Link Cell To Sheet & Cell Stated By User
I have a macro that inputs a sheet and cell from the user. when the macro tries to make a formula it outputs =data!'AE3'. I need it to output =data!AE3

Dim Sheet As String
Sheet = InputBox("Take Data from where?")
Dim startcell As String
startcell = InputBox("Start Cell?")

ActiveCell.FormulaR1C1 = "=" & Sheet & "!" & startcell & ""

View Replies!   View Related
Select Case With Msgbox Pop Up
I don't see what I am doing wrong in this code using "Select Case". When activated and the correct string is entered I should get a msgbox pop up.

View Replies!   View Related
Link A Cell To Another Cell On Same Worksheet Using A Formula
Is it possible to link a cell e.g. A10 that has a time value in it (there is a formula in this cell that puts in the time value) to another cell in a range of cells e.g. B1:B1000 that has the same time value?

I know someone out there knows how to do this.

View Replies!   View Related
Pop Up Reminder Listing Cell Then Go To It On Yes
Column B on worksheet3 has a list of dates on it. Column C states set reminder. Column D states how many days before reminder i.e. 3, 7, 10, 14. If the reminder is set to on. Can VBA code be run when the Workbook (or worksheet) that checks this criteria then a pops up is displayed outlining the event (say Cell A)?

Also is it then possible to have on the pop up - Go to this event (i.e. row of data?)

View Replies!   View Related
Calendar Pop Up On Specific Cell
I have search through this forum and gotten all info necessary to set up a calender pop up except for one piece.

I am using excel 2003 with XP and would like to put got on a work sheet so if I select range K31:m37 my calendarfrm will show. I have seen code for it to work with a date formated field but I would prefer it work on a the range only.

View Replies!   View Related
Pop-up Calendar On Cell Click
Is there a way to make a cell that when you click it a calendar pops-up and you can click a date on that calendar to auto-fill in that cell?

View Replies!   View Related
Pop-up Calendar When Cell Is Clicked
Is it possible to modify the following codes so that if the active cell is formatted as Date when the cell is clicked the pop-up calendar shows.

View Replies!   View Related
Pop-Up Message If Cell Value Not Reached
Is there any code to pop up a message each time a cell value is not reached. For ex if the resulted formula in A1 is less than 0 to pop up a message "LOOSE"

View Replies!   View Related
Expression For Pop-up Message Based On Cell Value
I have been reading the different post here on the forum.
I have found a snippet of code that will open a pop-up message from a value of a cell. I would llike to do this on one of my reports. Here is the scenario.

Range (R5:S5) 0.15 them MsgBox "Note Must Be Entered For +/- 15% change"
But There are 14 different cells that I want this to work for. The value differs from day to day, and this should pop-up happen without a user having any actions other then the calculated value. But ones the note is entered in the "Notes: cell the message will not return.
Hope I explained it correctly.

The value of the cells in question are calculated in each cell with a formula example "=IF(ISERROR(Z20/H5),0,IF(ISERROR(Z20/H23),0,(Z20/H23)))"


View Replies!   View Related
Message Box To Pop Up When Cell Active
I have used to code below to active message boxes for 3 different cells - however the 2nd and 3rd time the code is not working....

View Replies!   View Related
Click On Cell Makes Calendar Pop Up
I have read through numerous posts, but cannot get one thing to work. I am using Excel 2003, and am trying to get a calendar to pop up, to select a date, and then return that date to Cell B2.

I was successful at making the calendar pop up by the following methods:
1. Added a button to the toolbar, and assigned the Calendar Macro to it.
2. Using VB, added a sub-menu item to the right-click (context) menu, using the code below.

Private Sub Workbook_Open()
Application.OnKey "+^{C}", "Module1.Macro2"
End Sub
However, my goal is to make the calendar appear when I click on cell B2.
I tried using the following code, but when I click on B2 nothing happens.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$2" Then UserForm1.Show
End Sub
I also tried:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
With Worksheets(ActiveCell.Worksheet.Name)
If ActiveCell.Column = 2 Then
If ActiveCell.Row = 1 Then
UserForm1.Show
End If
End If
End With
End Sub

View Replies!   View Related
Pop-up Message For Cell Selection Or Mouse Over
I was just wondering if it was possible to get a collapsible menu/dialog box
for excel when a user clicks on the cell of interest. I don't want to use
the collapsible list function as I would rather the user be able to click on
the cell of interest and then have that cell produce maybe another
window/dialog box which will show the user what I have put in there - maybe a
chart or table or just a set of data - and perhaps allow them to cut and
paste the data as well? However, most importantly, I just want a
dialog/window box to appear rather than having to group and use the
collapsible list function. I've attached an image of what I have in mind.

View Replies!   View Related
Creating A Pop-up Window With Specific Cell Data
I'm basically creating a file where a userform comes up when you open the workbook, blocks the access to the actual workspace so that no manual entry can be done. What the userform allows you to do is add a new entry to the database (the userform has some text boxes where we type in stuff like location and name or age) after having found the next empty row in the enormous database (3.000 lines)

After having clicked the OK button in the userform and added the data to the database, I would like the userform to have a pop-up message box with specified text like:

"The number assigned to this entry is:" and then I would like to add a variable with excel using the cell in column D of the same row of the new entry. So the end result would be :


The number assigned to this entry is: 01

View Replies!   View Related
Link To Cell Instead Of Getting Cell Data
I want to create a summary page with the tab name and a link to the contents in a specific cell. In the code below, I can get the sheet I want but in the second column, I would like to link to the data instead of getting the data in the cell. Can I do this with a simple modification to this

Dim a As Long
Sheets.Add.Name = "Notes"
For a = 1 To Sheets.Count
Worksheets("Notes").Cells(a, 1) = Worksheets(a).Name
'The next line gets me data, but I want to link to this cell in all worksheets
Worksheets("Notes").Cells(a, 2) = Worksheets(a).Cells(15, 18)
Next a

View Replies!   View Related
Link A Certain Words In A Cell With Another Cell
For example, Cell A1 = July 2009 Cell B1 = July 2009 MTD. how to change 'July 2009' in cell B1 automatically in respond to the changes in cell A1.

View Replies!   View Related
Range Select Statement To Select A Cell
I want to put a range select statement to select a cell and count down 10 cells and copy.

View Replies!   View Related
Select Specific Cell Then Select The Row
I have column A with various values in cells.

For instance, DG, GS, HG etc

I wanna do if a cell in column A is equal to DG then select the entire row that contains the cell. then call other sub.

View Replies!   View Related
Macro That If I Hold Control + Shift + A I Will Get A Pop Up Saying "Your Amount Is (value Of The Cell)
I have an excel sheet and I want a Msg pop up to show a certain amount from a specific cell. So if the cell shows $100. I want to a do a macro that if I hold control + shift + a I will get a pop up saying "Your amount is (value of the cell).

I can only get it to work if I want the vale from an active cell.

MsgBox "The value in the active cell is " & ActiveCell.Value & "."


View Replies!   View Related
Link To Any Cell
I would like to ask if there's a way that i can create a link in a cell to another cell. Sample: in cell A1: there's a word "click to go to cell A150" in this case i dont have to use scroll down to go to cell A150.

View Replies!   View Related
Link To Another Cell
I would like to have a link in a merged set of cells that puts the insertion point to another cell. Scenario: In cell k30, the user puts in the amount of credit card debt a individual has, and scripts the user based on that information. Later on, they get a more accurate running total of the amount of debt and need to change the amount in k30 for an accurate quote. After ther running total, in cell j172(a merged box for instructions) i instruct the user to be sure to enter the new total in cell K30.

Questions:
1. Is there a way to put a button or a link that would put the insertion point back up to K30 automatically, but allow the user to change it themselves and not change it automatically?

View Replies!   View Related
Change Cell Colour When Select Cell
I have VBA code that changes the cell background colour in column A based on criteria in column B. What i want to do is select a cell in the same row in a range column O:AB and change the background colour to the same as column A. This action is for rows 4 to 41.

Basically i just want to click in a cell and for that cell's background colour to change and match the colour in column A.

View Replies!   View Related
Link Image To Cell
In Excel, I have a sheet for each team that I manage. Each sheet lists the team members and displays their picture below their names. Some people are on multiple teams/sheets.

I have a master list with everybody's name and picture that I copy and paste the pictures from when putting a team together. This has become a very tedious process.

Is there a way I can type the person's name on a team sheet and have their picture automatically appear below their name? I don't know if this can be done with some kind of lookup or if it will involve VB. I tried making the picture the background of an Autoshape or comment, but I could not figure out how to dynamically change the picture based on the name in a cell.

View Replies!   View Related
Use A Cell Value In A Address Link...
I have is a summary worksheet with two columns. One column is for Project ID number and the other is an address link to a specific cell in the worksheet corresponding to the Project ID. Perhaps the best way to explain this is by giving an example:

Project ID (Column 1)
00-111

Balance (Column 2)
='C:Financial Sheets[00-111.xlsx]Phase_21'!$H$1

As you can see the spreadsheets are named after the Project ID number. What I would like to do, if possible, is instead of typing in the name of the spreadsheet for each project in column 2 (Balance), I could somehow reference the cell value in column 1 (Project ID). Something like this:

Project ID (Column 1)
00-111

Balance (Column 2)
='C:Financial Sheets["A2".xlsx]Phase_21'!$H$1..........

View Replies!   View Related
Link Data In 1 Cell
Sample data:

Machine Part Number machine 1 123 machine 2 123 machine 3 123 machine 1 123 machine 2 456 machine 1 456 machine 3 456

i need to based on tis sample data come out with sth like tt:

Used In: 123 Machine 1, Machine 2, Machine 3 456 Machine 2, Machine 1, Machine 3

I need to group those machines under 1 part number. For instance, part 123 is used in which machines, I need to state them in a way like above. But repeated should not be stated again.

View Replies!   View Related
Link Cell Formats
Is there a way for your linked data to cary over formatting such as Bolds, borders, fonts and colors?

View Replies!   View Related
Find Which Cell Contain Link
I have a file contain some links with the other file. I want to remove these links but I don't know which cell contain the links. Is there anyway that can let me know which cell contains links so i needn't search one by one?

View Replies!   View Related
Link Tab Name To A Cell Without Using A Macro
Is there a way of embedding a formula in a worksheet so that the tab name of each worksheet is linked to a value in a cell on that sheet? (I don't want to run a macro)
In other words if the cell name is changed, the page name changes automatically.

View Replies!   View Related
Spin Button Link To Another Cell
how to linked the "small change" value in a spin button to take the value of another cell?

View Replies!   View Related
Link Textbox To Cell/Range
How to set up textbox which value is in a spreadsheet and not the user input?

View Replies!   View Related
Possible To Link The Name Of A Tab To A Cell In Its Corresponding Worksheet
if it is possible to link the name of a tab to a cell in its corresponding worksheet.

View Replies!   View Related
Link To A Cell From A Commandbar Control
I have a right click event for a cell where I create a custom commandbar with single or multiple control buttons based on the cell value. I want to link each control button to another cell in the same sheet.

View Replies!   View Related
Automatically Generate The Link Cell
A1, B1, C1, D1, E1, I1, J1 & D3 all linked to L1 thru S1 perspectively But when I copy the highted box and paste it, A4 automatically link to L4, as well as other fields. create a macro where excel automatically generate the link A1 = L1, A4 = L2, A7 = L3 and other fields perspectively all the way til the end?

View Replies!   View Related
Cell References Inside A LINK
is it possible inside this link to put a variable reference? for example to have a cell in my excel which in this case would be Report FY09 and if i change it to Repot FY08 the link would be c:Report FY08[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4 or in another case if i have the name of the sheet like

='Report FY09'!D4
to do it
='Report FY08'!D4

or even the excel file
c:Report FY08[PPV REVENUES FY 09 - Actual.xls]PPV Actual'!$C$4:$BB$4
to do it
c:Report FY08[PPV REVENUES FY 08 - Actual.xls]PPV Actual'!$C$4:$BB$4

View Replies!   View Related
Link Cell To Sheet Tab
Can you link a cell to a sheet tab. If yes how?

View Replies!   View Related
Link Cell Contents Across Worksheets?
I work for an IT company who build their own PC's. And we use a simple Excel 2003 spreadsheet to piece-together and price-up PC's for retail, I've attached an example of the spreadsheet for you to see. It uses basic formulas so we can see at-a-glance things like VAT figures, margin, profit etc. Each PC we sell is contained within one Excel file, and each PC has it's own Workbook tab.

The problem I want to solve is whenever we change a component or price, we have to do each system manually, which gets very repetetive and time consuming. What I'd like to be able to do is change the price of, let's say, the motherboard, and have the price be reflected across each of the PC's using that same motherboard on each seperate tab. This same system would apply when we change a product name, product ID etc.

View Replies!   View Related
Link Content Of Textbox To A Cell
I have a Textbox in Sheet1 where there is some text or anything. I want to link this content to another textbox or cell in Sheet2.

How to do it? Is it possible to do without macros?

View Replies!   View Related
Link Changing As A Result Of A Value In Another Cell
In a worksheet I want that a link changes, after I change a value in another cell.

Example:
When cell A1 is 2006_04 the link should be:

C:/2006/2006_04/[...xls]Page1'!A1

When cell A1 is 2006_05 the link should be:

C:/2006/2006_05/[....xls]'!Page1!A1

View Replies!   View Related
Link Cell To Textbox On UserForm
I am creating a user interface for inputing info into a sales order, and then printing the sales forms already pre-filled based on the user's input. SO, I need the user to be able to type text into a textbox that is in a multipage control that is in a userform, and then have it automatically populate a specific cell in my workbook. Seems like this should be relatively simple, but I am just getting started with vba and can't seem to figure this out.

View Replies!   View Related
Link Workbooks Using Cell Values
I need to link to a different workbook but using cell values.

For example, in the attached file in cell B4 it looks like this:

='C:Documents and SettingsAdministratorDesktop[2508 Howell Jan-Apr 2008.xls]Week 9'!$D$20

I need a way to change Week 9 in the above formula using a validation list.

I would also like to know how to specify the above workbook referenced using a cell as well, for instance, C:Documents and SettingsAdministratorDesktop[2508 Howell Jan-Apr 2008.xls] would be the contents of a cell or the ability to click on a cell and have it bring up an open dialog box to browse to the file and input it's path into that cell.

View Replies!   View Related
Link Userform Textbox To Cell
How do I refer to the contents of a userform's textbox on a worksheet?

The userform will be opened, edited, and closed by the user. I would like to be able to refer a cell on my sheet to that textbox so that they always have the same content.

View Replies!   View Related
Drop Down Cell Link Reference
I have 6 worksheets that are identical cosmetically. Each has the same drop down box list with the same name (dropdown1), however the cell link on each sheet is different. (ie. sheet1 dropdown1 cell link refers to a sheet ' lookup' cell $K$1, sheet2 dropdown1 cell link refers to sheet 'lookup' cell $K$2, etc.) I have the same command button in each sheet that performs the same task so I wanted to keep one module for all 6. Problem is I set a variable to the cell link in the code, and this has to be changed.

DropDownValue = Sheets("Lookup").Range("K1").Value

Is there any way I can set this variable using a property of the drop down list?

DropDownValue = dropdown1.celllink

I don't want to create 5 more duplicate modules just to change this one bit of code (I only use it this time in the code!). If there is no way to get the cell link value of the drop down, could I possibly put a worksheet change event on the lookup sheet to populate a certain static cell with the value of the last cell change?

View Replies!   View Related
Use Cell Value To Automatically Generate Link
For non-blank cells in the range C11:C65536, I want to have a hyperlink automatically generated (in the same cell), using the cell value as a relative variable in the link itself. One intended use for this is to populate the range with stock symbols, and have it generate hyperlinks to the following address:

http://news.moneycentral.msn.com/tic...asp?Symbol=XXX

Where XXX is the stock symbol in the given cell.

View Replies!   View Related
Update Link With File Name In Cell
I'm sure this is an easy one but it's unfortunately beyond me. I have a update links formula in which I would like for it to update with the name of the file being in a cell. Example:

The file name is Week20.xls

Cell A1 has the value of Week20.xls using a formula (="Week" & A2 & ".xls")

Currently I have it by looking at the actual file location like this: ='C:Documents and SettingsMy DocumentsWeekly Sales6 Sales Comparisons[Week20.xls]Daily Comparisons'!$I$4

But rather then pointing directly to the file path I want it to update by the name of the file in A1. So I'm sure its something as simple as replacing [Week20.xls] with some formula but I don't know what that one is.

View Replies!   View Related
Link Reference From A String In A Cell
I need to have a link to data in another file. The file will be in the same directory, however, the name of the file I need to link increments daily. I have a string being generated already with the name of the file I want to link to. I can easily add a cell reference to that string, but how do I use that string value in a link? Or - how do I use quick'n'easy VBA to snatch the required cell's data?

e.g.
Required data is in the file "production 060723.xls", in sheet "Daily Production", in cell "E2". Current file has a string being generated in a cell:
"\server1production dataproduction060723.xls"

The following day, the required data will be in a file called "production 060724.xls", same sheet, same cell. The current file's string data will also update to reflect the needed file. I know that similar questions have been asked here - but none that I saw in my search seemed quite what I need. Even if someone can direct me to the right thread, that would be great.

View Replies!   View Related
Link Cell To Picture Or Shape
It's difficult to explain, the attached shows the situation better. Basically there's a picture that is somehow linked to a cell. But, you can update the picture or the cell and the other one gets updated.

View Replies!   View Related
Hide Columns Based On A Cell Link
I need to hide columns in a spreadsheet without using the hide/unhide columns option. I found an article which suggested setting up a combobox from the forms toolbar, this is populated by an input range and linked to a cell for a numeric value. The article although using a macro to hide rows suggested this code


Private Sub ComboBox1_Change()

If ComboBox1.Value = "A" Then
ActiveSheet.Range("1:3").EntireRow.Hidden = True
ActiveSheet.Range("4:6").EntireRow.Hidden = False
ElseIf ComboBox1.Value = "B" Then
ActiveSheet.Range("1:3").EntireRow.Hidden = False
ActiveSheet.Range("4:6").EntireRow.Hidden = True
End If
End Sub

I want to amend this code so that when the number in my linked cell changes the various columns are hidden.

For example if the cell link number = 1 hide columns e to az if the cell link number = 2 hide columns d and f to az etc.

I have had varying success with amending this code to entirecolumn.Hidden and changing the Combobox1. to dropdown1. but am unable to get it to work, I also stupidly deleted the code that was partially working and am now unable to remember what I'd done.

View Replies!   View Related
Formula To Dicate Link Between Checkbox And Cell
I'm creating a spreadsheet which will have a grid of hundreds of check boxes (used to record progress on a project). In order to use the value of the check box in calculations, I'm linking each checkbox with another cell. So, if the checkbox is in cell F10, then i might link it with cell AF10, which is where the TRUE and FALSE indicators are.

If I copy the last row (which has checkboxes--let's call it row 99), and copy it below to expand the grid, the check boxes in the new row are still linked with row 99 cells (i.e., all the new check boxes in column F are still linked with AF99). So, presently I'm having to go through and manually re-link each pasted check box to a new cell.

Is there a way, using something along the lines of the INDIRECT function, where I can have a formula dictating what cell each checkbox is linked with, so that when I copy and paste a large number of these, they automatically point to the new cell (such that, F99's check box points to AF99, but if I copy this F99 check box into cell F115, then it would automatically be linked with cell AF115)?

View Replies!   View Related
Link Filename Of Workbook As Text In A Cell....
I have a workbook that gets saved many times with many different filenames.

All I want to do is have cell A1 display as text the name of the file.

eg similar to the date function, there should be a = filename function .

View Replies!   View Related
Pivot Table Filter Link To Cell
how to change this code to select the choice "NACID" from cell "D1" instead of being hardcoded?

Sub Pivot1()
ActiveSheet.PivotTables("PivotTable4").PivotFields("Group").CurrentPage = _
"NACID"
End Sub


View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved