Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandButton.Caption
Soniya,
If you don't unload form 2, just hide it, next time you access it, via Show not Load, then it will still have attributes of previous time as it will have remained in memory throughout this time. -- HTH Bob Phillips "Soniya" wrote in message ... Hi all, I have a user form having command Buttons "Print" and "Print Preview" and when either of this button pressed another user form activates in which user select items from listBox. In this second User form Command Button1 caption is based on the selection of the first userForm. If the user press "Print" in the first user form second user form comman Button caption will be "Print" otherwise "Print Previw" after the user select an item and (print or previw) a MsgBox ask whether to coninue with other selection. if pressed yes then my second Userform is activated again. My question is that is it possible to keep the caption in command button1 which was there the last time? since this time Userform1 is not involved. Just sore the last commandbutton1 caption and use it again if userform2 was not activated thru userform1. any help?!! TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CommandButton as array ? | Excel Discussion (Misc queries) | |||
Floating CommandButton | Excel Worksheet Functions | |||
Tooltip for my CommandButton | Excel Discussion (Misc queries) | |||
CommandButton - Userform | Excel Discussion (Misc queries) | |||
The font of the caption for the commandbutton is illegible. | Excel Discussion (Misc queries) |