Message box

[Wil Moosa]

I like to create a user form what more or less acts like a window to a specific cell. Filling in data in a blank field of the user form results into transferring this data into a specific cell on a specific sheet.

How can I do so?

 

[Paul B]

how about something like this,
Private Sub CommandButton1_Click()
Sheets("Sheet2").Range("B1") = UserForm1.TextBox1.Value
Unload UserForm1
End Sub

 

[Wil Moosa]

works well... with some help from http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q161514&
This message was edited by Wil Moosa on 2002-11-06 18:13