Not sure David.

I tried her also on XL 2000, and it worked fine.

Want to post a workbook to me?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davidm" wrote in
message ...

Hello Bob,

Excuse my obtuseness. If the procedure

Sub RetrieveCounter()
Load UserForm1
UserForm1.ShowNumberofControls
MsgBox UserForm1.k
Unload Userform1
End Sub

is run from a general module, it throws up another compile error
message: *Member or data member not found* with both the sub title Sub
RetrieveCounter()and UserForm1.ShowNumberofControls highlighted. In all
this, k is declared *Public* at the Userform code module level and
should be truly global. I am using Xl2000 and could this put down to
paying the laggards' price?

David.


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=488169