Edit cell and activate userForm

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

Hi All,

I have a userform with a list box items from my shhet 1
column A

when i click edit on the user form i want to get focus to
the sheet (without closing userform)and after editing the
cell i want to be able to use the form agian

how can i do this?

TIA
Soniya
 
Make you userform modeless.

UserForm1.Show vbModeless




Range("A1").Select
AppActivate Application.Caption

to set the focus to a cell on the sheet.
 
Back
Top