Launching form blocks cell selection
 

Dear Excel experts,

I created a user form that requires input from a cell. After launching
the form, I cannot modify the contents of the cell. In fact, I am
blocked from selecting any parts of Excel until I close the form. Is
there some way to work around this problem?

Thank you for helping.

Launching form blocks cell selection
 

Set the form's ShowModal property to False.

Launching form blocks cell selection
 

NYL laid this down on his screen :
Dear Excel experts,

I created a user form that requires input from a cell. After launching
the form, I cannot modify the contents of the cell. In fact, I am
blocked from selecting any parts of Excel until I close the form. Is
there some way to work around this problem?

Thank you for helping.

UserForm1.Show vbModeless

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Launching form blocks cell selection
 

hi,

UserForm1.Show 0 '(ShowModal)

or :
Set x = Application.InputBox(prompt:="Select range", Type:=8)
Application.Goto Sheets(2).Range(x.Address)

--
isabelle



Le 2012-04-03 22:33, NYL a écrit :
Dear Excel experts,

I created a user form that requires input from a cell. After launching
the form, I cannot modify the contents of the cell. In fact, I am
blocked from selecting any parts of Excel until I close the form. Is
there some way to work around this problem?

Thank you for helping.