How can I use a worksheet while running a userform?

  • Thread starter Thread starter Leo
  • Start date Start date
L

Leo

Probably the most basic question in userform programming:

I have created a userform in excel 97. When I run the userform it
works perfectly, but I cannot modify the worksheet (cells etc). I can
access the worksheet through buttons on the userform (for instance
ref-edits), but I cannot actually work with the worksheet.

What I want to create is a userform that hangs around in the background
until you need it.

Advice will be appreciated :)

Leo
 
That was exactly it! I havn´t figured out how it works yet, and if
don´t I´ll be back.

Thanks.

Le
 
You can use Conditional Compilation to test if you are running in
VBA6, which is the version of VBA used in Excel 2000 and later.
E.g.,

#If VBA6 Then
Userform1.Show vbModeless
#Else
Userform1.Show
#End If

Note that the # characters are required.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top