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: 10
Default HELP NEEDED: Class Modules Vs Focus/Enter Event on Combobox

Hi All,

Here is my problem which hopefully somebody can assist with:

I have a userform (Critique) which has a number of combo boxes added to it
dynamically because the amoun of these boxes can vary depending on other
cicumstances.

I now have a need to classify each combobox into one of two categories - the
way I do this is through using the tag property to differentiate.

Depending on the tag proprerty (say it is either 1 or 2) for the currently
in use Combobox, I need it to then make a textbox visible and another
invisible - and vice versa.

In other words, I have 2 textboxes to grab input but which textbox is
visible depends on the tag of the combobox that is currently active.

I tried to do a class module for the "Enter" event but it doesn't work. The
"Change" event works but this will not be good enough for me as it will
require information to change before it runs whereas I want the class module
to run the moment somebody tabs into the combobox or clicks into it.

If somebody can please help it would be appreciated and I extend my thankyou
in advance.

Regards,
Clint

 
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
MsgBox in Enter event causes combobox not to run Change event Richard Excel Programming 0 March 6th 06 02:52 PM
MsgBox in ComboBox Enter Event does not allow update Richard Excel Programming 1 March 3rd 06 08:15 PM
Basic question - modules and class modules - what's the difference? Mark Stephens[_3_] Excel Programming 9 May 8th 05 11:48 AM
Further Clarification with Event Handlers & Class Modules Kevin H. Stecyk[_2_] Excel Programming 2 January 25th 05 05:10 PM
Event - RaiseEvents Within Class Modules John Peterson[_3_] Excel Programming 4 July 17th 03 12:53 AM


All times are GMT +1. The time now is 06:52 AM.

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"