Edit cell and activate userForm

[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

 

[Tom Ogilvy]

Make you userform modeless.

UserForm1.Show vbModeless




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

to set the focus to a cell on the sheet.