Thread: How can I use a worksheet while running a userform?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How can I use a worksheet while running a userform?
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



"cecilia12345" wrote
in message ...
how you do this if it`s excel 2000?


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote