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: 6
Default Help sought re vbmodeless form rendering a class module useless

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
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
CLASS MODULE & SIMPLE MODULE FARAZ QURESHI Excel Discussion (Misc queries) 1 September 7th 07 09:32 AM
vbModeless user form crashes Excel Plutopotamus Excel Programming 2 January 28th 05 03:19 PM
Class module in VBA romkeys Excel Programming 1 August 19th 04 06:20 PM
let and get in class module Doug Glancy Excel Programming 3 June 30th 04 02:30 PM
Variable from a sheet module in a class module in XL XP hglamy[_2_] Excel Programming 2 October 14th 03 05:48 PM


All times are GMT +1. The time now is 09:09 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"