| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open "Insert Hyperlink" popup window with VBA?
Hi there
Is there a VB code that opens the "Insert Hyperlink" pop-up window? (i.e. does the same thing as "Ctrl + K" or "Insert|Hyperlink...") I want to be able to click on a botton (created from Forms toobar) to open the "Insert Hyperlink" pop-up window, so I can then choose an address from the pop-up window to go into a merged cell H32:AK32. Is this possible? Thanks in advance Sam (I'm not sure if my previous post was successful..sorry if this is a dupilcate) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open "Insert Hyperlink" popup window with VBA?
You can use following on the button:
Application.Dialogs(xlDialogInsertHyperlink).Show hth Carlo On Jan 17, 11:02*am, Sam Kuo wrote: Hi there Is there a VB code that opens the "Insert Hyperlink" pop-up window? (i.e. does the same thing as "Ctrl + K" or "Insert|Hyperlink...") I want to be able to click on a botton (created from Forms toobar) to open the "Insert Hyperlink" pop-up window, so I can then choose an address from the pop-up window to go into a merged cell H32:AK32. Is this possible? Thanks in advance Sam (I'm not sure if my previous post was successful..sorry if this is a dupilcate) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open "Insert Hyperlink" popup window with VBA?
Hi Carlo
Thanks for your prompt reply. It works beautifully! Sam "carlo" wrote: You can use following on the button: Application.Dialogs(xlDialogInsertHyperlink).Show hth Carlo On Jan 17, 11:02 am, Sam Kuo wrote: Hi there Is there a VB code that opens the "Insert Hyperlink" pop-up window? (i.e. does the same thing as "Ctrl + K" or "Insert|Hyperlink...") I want to be able to click on a botton (created from Forms toobar) to open the "Insert Hyperlink" pop-up window, so I can then choose an address from the pop-up window to go into a merged cell H32:AK32. Is this possible? Thanks in advance Sam (I'm not sure if my previous post was successful..sorry if this is a dupilcate) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open "Insert Hyperlink" popup window with VBA?
On Jan 17, 12:08*pm, Sam Kuo wrote:
Hi Carlo Thanks for your prompt reply. It works beautifully! Sam "carlo" wrote: You can use following on the button: Application.Dialogs(xlDialogInsertHyperlink).Show hth Carlo On Jan 17, 11:02 am, Sam Kuo wrote: Hi there Is there a VB code that opens the "Insert Hyperlink" pop-up window? (i..e. does the same thing as "Ctrl + K" or "Insert|Hyperlink...") I want to be able to click on a botton (created from Forms toobar) to open the "Insert Hyperlink" pop-up window, so I can then choose an address from the pop-up window to go into a merged cell H32:AK32. Is this possible? Thanks in advance Sam (I'm not sure if my previous post was successful..sorry if this is a dupilcate)- Hide quoted text - - Show quoted text - You're welcome and thanks for the Feedback Carlo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Discussion (Misc queries) | |||
| Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Worksheet Functions | |||
| Suppress popup "Do you really want to save..." after open and immediate close of excel sheets ? | Excel Programming | |||
| get rid of the "insert option pop up window paintbrush" | Excel Discussion (Misc queries) | |||
| VBA command to say "yes"/"no" to popup window | Excel Programming | |||
![Sam Kuo[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
