Maybe...

Private sub Commandbutton1_Click()
Sheets("Form").range("a64").value = Textbox1.Text
End Sub

It'll do the work when they hit that Commandbutton1 (ok???) button.


cassy01 wrote:

this doesnt seem to work larry:

When i click on TextBox4 i would like a input box to appear where the
user can enter a value (1-89).

When the user presses enter the value in that box appears in cell
"A64"

the sheet is called "Form"

Many Thanks
Benn

--
cassy01
------------------------------------------------------------------------
cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780
View this thread: http://www.excelforum.com/showthread...hreadid=474205

--

Dave Peterson