Richard has attended:
Excel VBA Intro Intermediate course
User Froms / command button - on click
Hi there,
im trying to put a button - command button i think, on a worksheet, actually on the worksheet, not in the tool bars. I can create the button, but I dont know how to get this button to appear on the worksheet. This area was covered on the course, but I just cant remember how to do it - sorry.
I then want this button, if clicked upon to run a procedure already created, I think this part is just done by setting it up so that on 'click' the button calls the necessay procedure.
I know this is probably not complicated - I remember it being an easy part of the course, so im a bit embarassed about asking! Hope the above is clear - please let me know if you need any further information.
Thanks again for your help.
RE: User Froms / command button - on click
Hi Richard
Thank you for your question
If you click on VIEW-TOOLBARS and select the control toolbox. Then click on the command button icon and draw it on the worksheet.
Finally, click on the view code button on the control toolbox (3rd button from the top). This creates an on click procedure for the button. Simply type the appropriate call procedure at this point
Hope this helps.
Regards
Stephen