adding content to a cell

C

cedtech23

I have a text box called txtName on my form that a user input data.
want that data to popluate to a cell C7 in a worksheet called hrfrom
when the user clicks on the command button call cmdOK. I tried th
code below but no luck. Any ideas??

Private Sub cmdOK_Click()
C7.Value = txtName.Value
Unload Me
End Su
 
N

Norman Jones

Hi Cedtech,

Try:

'=============>>
Private Sub cmdOK_Click()
Sheets("hrfromm").Range("C7").Value = txtName.Value
Unload Me
End Sub
'<<=============
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Help 2
Activate a Pop Up Calendar Every Time a User Double Clicks in Column A or C 5
Why doesn't this work 1
Copy data to sheets by name 3
Create a yes no message on a command button on click 0
Userforms submit button to clear after it enters data? 2
Form Unload? 2
Populate Cell with Content of Text Box 10

Top