Selecting a cell in when form is open

[DougP]

Selecting a cell in when form is open
While ther form is up we can't pick anythng on the spreadsheet behind.
I created Userform1 and I want to allow the user to pick a cell and then choose a item from its list box on the form to put in that cell.

Any ideas

DougP, MCP, A+

 

[rmikesmith]

DougP,

Open the Userform as a modeless form:

MyForm.Show vbModeless

Regards,
Mike

 

[DougP]

How do I put the data in the cell they pick?

DougP, MCP, A+

 

[SkipVought]

Data from where to where?

ActiveCell.Value = Userform1.Textbox1.Text

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}