Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dialog box dynamic text
Hi, I've created a dialog box in Excel 2000, and I'm wondering if it's possible to have text in the dialog box which changes according to a specific cell in a worksheet?!? Thanks, Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=397961 |
#2
|
|||
|
|||
If you're using Excel 2000 you should be using a userform rather than a
dialog sheet. but you can have dynamic text in a dialog sheet dialog when the dialog appears. This is an example of code that sets the caption of a label from the text in cell A1: Sub a() With DialogSheets("Dialog1") .Labels("Label 4").Caption = "abc" .Show End With End Sub -- Jim "Voodoodan" wrote in message ... | | Hi, | | I've created a dialog box in Excel 2000, and I'm wondering if it's | possible to have text in the dialog box which changes according to a | specific cell in a worksheet?!? | | Thanks, | Dan. | | | -- | Voodoodan | ------------------------------------------------------------------------ | Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 | View this thread: http://www.excelforum.com/showthread...hreadid=397961 | |
#3
|
|||
|
|||
Jim, That's just what I needed, thanks. I just changed the "abc" bit to a Range("??") value and it works fine. Thanks, Dan. -- Voodoodan ------------------------------------------------------------------------ Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597 View this thread: http://www.excelforum.com/showthread...hreadid=397961 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic cell reference within a text string | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Dynamic Text in a Chart | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |