Link content from dialog box to a worksheet cell

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

Guest

Hi,

i have the problem, that i can´t link an Excel diaslog box entry to a
worksheet cell.
Thanks for your interesting and help.

Best regards,

Olga
 
Good afternoon Olga

Do you mean a userform? If so, try this:

Range("A1").Value = TextBox1.Value

This will put the contents of TextBox1 into cell reference A1.

HTH

Dominic
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Blank Sheet with Gridlines 11
spreadsheet disappeared 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel2007 limiting Pre-2007 Worksheet protection passwords to 15 c 2
copying cell contents from one worksheet to another (re-sorted lis 2
Cells act as if they are linked-link does not display in entry bar 1
Copy to another worksheet 3

Back
Top