ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ClickMe (https://www.excelbanter.com/excel-programming/418192-clickme.html)

Jim Bunton

ClickMe
 
I've drawn a button - ClickMe on a work sheet
and written a little code for it.
[I am used to vb code in the Access environment]

NOW!! how do I make the button user clickable please?

--
Jim Bunton



JLGWhiz

ClickMe
 
If your button is from the Forms tool bar, right click the button and click
assign macro, then click on the macro name for the code you wrote.

If your button is from the Control Toolbox, you will need to enter design
mode by pressing Alt + F11 to open the VB editor. Then click the design icon
and right click the button, select view code and enter your code in the click
event of the button.

"Jim Bunton" wrote:

I've drawn a button - ClickMe on a work sheet
and written a little code for it.
[I am used to vb code in the Access environment]

NOW!! how do I make the button user clickable please?

--
Jim Bunton




Per Jessen

ClickMe
 
Hi Jim

You have to exit design mode.

The "Exit Design Mode" button is found on the control toolbox menu.

Regards,
Per

"Jim Bunton" skrev i meddelelsen
...
I've drawn a button - ClickMe on a work sheet
and written a little code for it.
[I am used to vb code in the Access environment]

NOW!! how do I make the button user clickable please?

--
Jim Bunton





All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com