Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Title on MsgBox
My workbook has a Public Constant as an InpTitle for msgBoxes. I want that
constant to be a user title that is in the spreadsheet itself. Users enter their own title in the spreadsheet and that come up in the msgBox. Can I make such a reference? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input Title on MsgBox
It can't be a constant but it can be a Public variable:
Public strTitle as String Set the variable somewhere in a Sub, that you could call via a button in the sheet or whatever is best suitable: strTitle = Cells(1) Then in your MsgBox: Msgbox "Prompt", , strTitle RBS "pkeegs" wrote in message ... My workbook has a Public Constant as an InpTitle for msgBoxes. I want that constant to be a user title that is in the spreadsheet itself. Users enter their own title in the spreadsheet and that come up in the msgBox. Can I make such a reference? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox Title | Excel Programming | |||
msgbox title | Excel Programming | |||
input box , msgbox, formula | Excel Programming | |||
Using different lines in an input- or msgbox | Excel Programming | |||
MsgBox and User Input | Excel Programming |