View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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