Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey guys,
Here is my problem: I have a form which has a button on it that when clicked, changes the form from modal to modeless - the reason for this is so people can then go to excel and copy and paste list of numbers into the form from a sheet they may have been emailed. The problem is that the form being modeless then renders class modules I have useless. The class modules are there so certain buttons and text boxes do the same things. In terms of my text boxes, the class module detects somebody has hit enter then makes the frame below it visible and ready for inputing more. This works perfectly until I make the form modeless - is there a reason for this and is there a way to kick the damn thing into working order? I tried the repaint option, thinking that a sokution to a modeless displayscreen problem i had may work but it didn't do the trick in this case. Thank you in advance for your help. Clint |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
vbModeless user form crashes Excel | Excel Programming | |||
Class module in VBA | Excel Programming | |||
let and get in class module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |