VBA Programming for Excel-Create a procedure in VBA
Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3, ) -Display a Message Box asking if you'd like to calculate another number (e.g. Do you want another number?) -This Message Box should give the option to click "Yes or "No - If the answer is "Yes, then another Message Box should display the value. Then on the active worksheet you should place the header "Values on cell A1 and start placing the calculated values in descending order on the same column . Repeat this until you have a series from 1 to 15. - If the answer is "No then display a Message saying "Ciao! and terminate the procedure. - Generate a series from 1 to 15. Copy your VBA code and paste to this word file, submit it on Ctools
Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3, ) -Display a Message Box asking if you'd like to calculate another number (e.g. Do you want another number?) -This Message Box should give the option to click "Yes or "No - If the answer is "Yes, then another Message Box should display the value. Then on the active worksheet you should place the header "Values on cell A1 and start placing the calculated values in descending order on the same column . Repeat this until you have a series from 1 to 15. - If the answer is "No then display a Message saying "Ciao! and terminate the procedure. - Generate a series from 1 to 15. Copy your VBA code and paste to this word file, submit it on Ctools
0 comments:
Post a Comment