Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2 questions from a beginner
Hi i have 2 questions on how to do things if anyone could help it would be great. I need to create a text box and a button where when you enter a number in the text and click the button it mutiplies the number, the question actually looks like this... a) Define a variable Mult in your code b) When the user clicks the button if the textbox has an empty string, set the variable Mult to 10. If it is not empty, set the variable Mult to the number they typed into the textbox. c) Use a for..next loop to fill in the values in column A and B as shown in the sample. Hint use the cell property. and the other one is 2) For Q2 start with a blank worksheet, with one button captions “Enter weights”. When the user clicks the button: a) Prompt the user with an inputbox to “Enter weight, enter 0 when done” b) Use a do while loop to read in the weights and store them in column one, starting in cell A1. c) As you read in the values, store them in a total and keep track of how many you read. d) When the user enters in a 0, print out the average weight in the final cell. If the user enters ages of 155, 200, 140, and 160 the example output looks like: This all looks foreign to me so any help would be GREATLY appreciated. thanks. -- Deaky220 Posted from - http://www.officehelp.in |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
something more efficient that =IF, and sytax questions | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
A few questions if anyone has a moment? | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
Puzzling Format Questions | Excel Discussion (Misc queries) |