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" wrote in
message ...
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.value

i know it doesnt work!

thank you,

Robert Couchman

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)
www.rondebruin.nl



"Robert Couchman" wrote in message
...
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.value

i know it doesnt work!

thank you,

Robert Couchman

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)
www.rondebruin.nl



"Robert Couchman"
wrote in message
...
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.value

i know it doesnt work!

thank you,

Robert Couchman


.