LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Display a selection while UserForm is in focus

Hi there folks.

I am using 2002.

In a user form demo I have been using, one of the really nice features
is that it keeps displaying the selection its subs are working on while
the form is in focus.

I am trying to achieve the same in my own application, and how to do
this seems to be eluding me. The following two examples of code do not
achieve the desired result.

Any suggestions would be really appreciated.

Thanks
Geoff

--------------------------------
Sub CommandButton1_Click()
UserForm3.Show
End Sub
--------------------------------
Sub CommandButton1_Click()
UserForm3.Show
Selection.Hidden = False
End Sub
-------------------------------

 
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
how to keep focus on txt_box in userform Pierre via OfficeKB.com Excel Programming 5 September 5th 05 03:46 PM
Object on userform can't get focus Jos Vens[_2_] Excel Programming 3 February 28th 05 11:50 PM
Focus on Control before UserForm(s) pop up Bob Phillips[_6_] Excel Programming 0 May 5th 04 04:03 PM
UserForm Loss Focus Orlando Magalhães Filho Excel Programming 2 September 5th 03 04:47 AM
removing selection focus in listbox Craig Wilks[_2_] Excel Programming 2 August 13th 03 12:15 PM


All times are GMT +1. The time now is 01:46 PM.

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

About Us

"It's about Microsoft Excel"