Link to home
Start Free TrialLog 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
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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