Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CommandButton as array ? apis Excel Discussion (Misc queries) 2 November 17th 11 05:36 PM
Floating CommandButton Richard Excel Worksheet Functions 1 April 29th 06 08:34 PM
Tooltip for my CommandButton LQs Excel Discussion (Misc queries) 1 December 2nd 05 09:53 AM
CommandButton - Userform Marcia3641 Excel Discussion (Misc queries) 2 July 21st 05 06:39 PM
The font of the caption for the commandbutton is illegible. DarkVader Excel Discussion (Misc queries) 2 November 30th 04 02:45 PM


All times are GMT +1. The time now is 04:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"