Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a User Input Form
Just want to say up front that this user group is very helpful and
supportive and has been an invaluable resource for me as I learn excel programming. My current challenge is to develop a user input form that would pop up from a command button on the active worksheet and prompt the user to input up to 13 different numbers for the day. Once the form is filled out the user would then press an "Accept" command button and the numbers in the form would then go assigned cells in the active worksheet. 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. TEA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a User Input Form
Thanks,
but the problem with this is that as you input data into the form, it goes straight to the worksheet and can't be undone. I should have stated this earlier, but one of the purposes of this form is to give the user a chance to review the data entered before accepting it and sending it to the sheet. So the form acts as a kind of "data buffer". Any suggestions will be appreciated. "merjet" wrote in message . net... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a User Input Form
You can use the code approach, with checks
before it, that I suggested. HTH, Merjet "Cody Dawg" wrote in message ... Thanks, but the problem with this is that as you input data into the form, it goes straight to the worksheet and can't be undone. I should have stated this earlier, but one of the purposes of this form is to give the user a chance to review the data entered before accepting it and sending it to the sheet. So the form acts as a kind of "data buffer". Any suggestions will be appreciated. "merjet" wrote in message . net... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) |