Launching form blocks cell selection

  • Thread starter Thread starter NYL
  • Start date Start date
N

NYL

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.
 
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.
Click to expand...

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
 
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 :
 
Back
Top