Link to home
Create AccountLog in
Avatar of krisrajz
krisrajz

asked on

Modeless UserForm-VBA

I've an excel sheet. On changing the content of the cell I would like to display a modeless form which require some user input.

How do I display such a modeless form ( I do not want to use showmodal kind of properties )

TIA
RAJ.
ASKER CERTIFIED SOLUTION
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of krisrajz
krisrajz

ASKER

OOPS!. Did not you know that the UserForm does accept vbModeless argument?

or

My versions of VBA IDE does not let me pass on the vbModeless argument

Please checkout.

RAJ.
RAJ

Modeless forms have been available in Excel VBA from version 2000 and up.

Dave
Please close the thread as there is no useful replies.

THANX

RAJ.
RAJ - your question was answered as asked.
My view is that this question was clearly answered.

Cheers

Dave