IS IT POSSIBLE TO:

When i click on a button a pop-up box appears where it asks the user to
enter a value then clicks "ok" ?

When clicking ok the value in the box is sent to cell "A64".

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

Hi Cassy01,

Try this in your userform and change the commandbutton and textbox name
and sheet name to fit.


Code:
--------------------

Private sub Commandbutton1_Click()
Sheets("Sheet1").Activate
Cells(64, 1) = Textbox1.Text
End Sub

Private Sub Textbox1_Change()
End Sub

--------------------


Hope this helps,

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=474205

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

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

Cassy01,

I'm confused on what you are trying to say. I assumed that you already
have a command button that prompts a userform. If not create one. Click
on design mode, click on the commandbutton then right click, pick view
code and place this code into the sheet. This will make the userform
appear.


Code:
--------------------

Private Sub Commandbutton1
Application.Visible = False
UserForm1.show
Application.Visible = True

--------------------


Make sure you have already created the userform before tyring this
code.

The codes given earlier need to be placed into the userform with the
textbox and commandbutton that you are intending to use.




Code:
--------------------

Private sub Commandbutton1_Click()
Sheets("Sheet1").Activate
Cells(64, 1) = Textbox1.Text
End Sub

Private Sub Textbox1_Change()
End Sub
--------------------


This was based on your first question below:

"When i click on a button a pop-up box appears where it asks the user
to enter a value then clicks "ok" ?"

When clicking ok the value in the box is sent to cell "A64".


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=474205