View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default Help with a User Input Form

I'm able to put together the form and command buttons, etc., but cannot
figure out the way to have the numbers in the form go to specific cells on
the active worksheet.


If you don't mind the contents of the cells appearing in the TextBoxes
when the UserForm is shown, you can use the TextBox's ControlSource
property, e.g. Sheet1!A1. Or you can put code behind the "accept"
CommandButton, e.g.:
Sheets("Sheet1").Range("A1") = TextBox1.Text 'or
Sheets("Sheet1").Range("A1") = TextBox1.Text 'or
ActiveSheet.Range("A1") = TextBox1 'or
ActiveSheet.Range("A1") = TextBox1.Text

HTH,
Merjet


 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.