calling a userform
 

i`m kind of new to vb programming, so all help will be appreciated.

Ive got a userform which i want to call from a sub, and run it, then
want to call another sub and just run that.

I was wondering how you would go about trying to call a userform (or
sub within a userform).

I tried the following

Sub Main()

deleteops 'delete ops

userform1 ' call userform

End Sub

but it doesnt work for the userform

Any ideas?

thanks

--
s_ali_hassa
-----------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...fo&userid=3532
View this thread: http://www.excelforum.com/showthread.php?threadid=55145

calling a userform
 

try

Userform1.show


hope this helps!

s_ali_hassan wrote:
i`m kind of new to vb programming, so all help will be appreciated.

Ive got a userform which i want to call from a sub, and run it, then i
want to call another sub and just run that.

I was wondering how you would go about trying to call a userform (or a
sub within a userform).

I tried the following

Sub Main()

deleteops 'delete ops

userform1 ' call userform

End Sub

but it doesnt work for the userform

Any ideas?

thanks.


--
s_ali_hassan
------------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...o&userid=35325
View this thread: http://www.excelforum.com/showthread...hreadid=551457

calling a userform
 

Hi,

What about..

UserForm1.Show

Ken Johnson

calling a userform
 

Userform1.Show

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"s_ali_hassan"
wrote in message
news:s_ali_hassan.29ci9c_1150210203.4301@excelforu m-nospam.com...

i`m kind of new to vb programming, so all help will be appreciated.

Ive got a userform which i want to call from a sub, and run it, then i
want to call another sub and just run that.

I was wondering how you would go about trying to call a userform (or a
sub within a userform).

I tried the following

Sub Main()

deleteops 'delete ops

userform1 ' call userform

End Sub

but it doesnt work for the userform

Any ideas?

thanks.


--
s_ali_hassan
------------------------------------------------------------------------
s_ali_hassan's Profile:
http://www.excelforum.com/member.php...o&userid=35325
View this thread: http://www.excelforum.com/showthread...hreadid=551457

calling a userform
 

nice one! tried it, and it worked.


--
s_ali_hassan
------------------------------------------------------------------------
s_ali_hassan's Profile: http://www.excelforum.com/member.php...o&userid=35325
View this thread: http://www.excelforum.com/showthread...hreadid=551457