Export textbox value into a spreadsheet cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, i am trying to export a value typed into a userform text box, to a cell in my spreadsheet, when i specify the location i want the data to go, i seem to end up with errors, can anyone please tell me what i need to input to get my text box information to go to a specific cell in a spread sheet

e.g. sheet1.range("c15").value = textbox1.valu

i know it doesnt work

thank you

Robert Couchman
 
Where did you put that code ?

--
Regards,

Juan Pablo González

Robert Couchman said:
Hello, i am trying to export a value typed into a userform text box, to a
Click to expand...
cell in my spreadsheet, when i specify the location i want the data to go, i
seem to end up with errors, can anyone please tell me what i need to input
to get my text box information to go to a specific cell in a spread sheet?
 
Hi Robert

You use the codename of the sheet in your code
Sheet1.Range("c15").Value = TextBox1.Value

This don't have to be the sheet with the name Sheet1 on the Tab

Try this

Sheets("Sheet1").Range("c15").Value = TextBox1.Value


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




Robert Couchman said:
Hello, i am trying to export a value typed into a userform text box, to a cell in my spreadsheet, when i specify the location
Click to expand...
i want the data to go, i seem to end up with errors, can anyone please tell me what i need to input to get my text box
information to go to a specific cell in a spread sheet?
 
Thank you for that idea, but im afraid that was one of my
original bits of code, and it didnt work.

i am trying to take the data from an open form and data
from a hiden form, then put both bits of information onto
the sheet.

yes, this code is correct if you are dealing with
information in a hidden form, but please explain the code
for dealing with open information.

Thank you,

Robert Couchman
-----Original Message-----
Hi Robert

You use the codename of the sheet in your code
Sheet1.Range("c15").Value = TextBox1.Value

This don't have to be the sheet with the name Sheet1 on the Tab

Try this

Sheets("Sheet1").Range("c15").Value = TextBox1.Value


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Robert Couchman"
Click to expand...
userform text box, to a cell in my spreadsheet, when i
specify the location
i want the data to go, i seem to end up with errors, can
Click to expand...
anyone please tell me what i need to input to get my text
box
 
Back
Top