Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Attached to AutoShape
Using Excel 2003
I have an object (and AutoShape) with the following macro attached to it, used to take the user to another worksheet. The user clicks on the object and the code moves then as directed. Sub GoToTFMWorksheetPage1() Application.ScreenUpdating = False Sheets("TFM Worksheet Page 1").Select Application.Goto Reference:=Range("A1"), Scroll:=True Application.Goto Reference:=Range("B100"), Scroll:=False ActiveWindow.Zoom = 100 Application.ScreenUpdating = True End Sub In addition, I need the user to be able to read a text message, similar to a hyperlink message, telling him the title of the worksheet they are about to go to. For example, when the user puts the cursor over the object, the cursor context changes to the pointing finger. I want to have a Text Box come up at that time. If the user clicks on the object, they will go to the worksheet. The technique used to do this would be used multiple times throughout the worksheets in the workbook. Would I add code to the above? What would the code be? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Attached to AutoShape
Click on your object while in DesignMode to prevent the Macro running
then goto Insert Hyperlink Select Place In This Document (left hand side) and add a screen tip (top right). You may then need to put code into the worksheet_activate() sub Private Sub Worksheet_Activate() ActiveWindow.Zoom = 100 End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Attached to AutoShape
You could just assign a hyperlink to the autoshape. Right click on it and
select hyperlinks. Then if you hover your mouse over the shape, you get a tool tip with the link. You can also probably right click on it and edit text to put a label that has the sheet name. It looks like you don't want to have the selection visible. You might be able to use the follow hyperlink event to achieve that part. -- Regards, Tom Ogilvy "Phil H" wrote: Using Excel 2003 I have an object (and AutoShape) with the following macro attached to it, used to take the user to another worksheet. The user clicks on the object and the code moves then as directed. Sub GoToTFMWorksheetPage1() Application.ScreenUpdating = False Sheets("TFM Worksheet Page 1").Select Application.Goto Reference:=Range("A1"), Scroll:=True Application.Goto Reference:=Range("B100"), Scroll:=False ActiveWindow.Zoom = 100 Application.ScreenUpdating = True End Sub In addition, I need the user to be able to read a text message, similar to a hyperlink message, telling him the title of the worksheet they are about to go to. For example, when the user puts the cursor over the object, the cursor context changes to the pointing finger. I want to have a Text Box come up at that time. If the user clicks on the object, they will go to the worksheet. The technique used to do this would be used multiple times throughout the worksheets in the workbook. Would I add code to the above? What would the code be? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox Attached to AutoShape
Thanks Tom, this works exactly as needed. Unknown to me, the code acts
before any hyperlink instruction. I entered the exact "hover" text as a screen tip. Very clean! Thanks Phil "Tom Ogilvy" wrote: You could just assign a hyperlink to the autoshape. Right click on it and select hyperlinks. Then if you hover your mouse over the shape, you get a tool tip with the link. You can also probably right click on it and edit text to put a label that has the sheet name. It looks like you don't want to have the selection visible. You might be able to use the follow hyperlink event to achieve that part. -- Regards, Tom Ogilvy "Phil H" wrote: Using Excel 2003 I have an object (and AutoShape) with the following macro attached to it, used to take the user to another worksheet. The user clicks on the object and the code moves then as directed. Sub GoToTFMWorksheetPage1() Application.ScreenUpdating = False Sheets("TFM Worksheet Page 1").Select Application.Goto Reference:=Range("A1"), Scroll:=True Application.Goto Reference:=Range("B100"), Scroll:=False ActiveWindow.Zoom = 100 Application.ScreenUpdating = True End Sub In addition, I need the user to be able to read a text message, similar to a hyperlink message, telling him the title of the worksheet they are about to go to. For example, when the user puts the cursor over the object, the cursor context changes to the pointing finger. I want to have a Text Box come up at that time. If the user clicks on the object, they will go to the worksheet. The technique used to do this would be used multiple times throughout the worksheets in the workbook. Would I add code to the above? What would the code be? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autoshape textbox | Excel Programming | |||
HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming |