ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Push the button (https://www.excelbanter.com/excel-programming/336247-push-button.html)

Chris

Push the button
 
Dear all,

I have currently made an Excel form that includes some radio bullets and
combo boxes. The functions behind the VBA controls work without any problems,
but the control dont always react.
When I have written some text in a cell and I did not exit the cell it is
not possible to enable a control I first need to exit the cell before I can
enter a combo box or a radio bullet.
I know that this is probably standard Excel behaviour, but I would like to
know if there is a solution.

Thanks for your help.

Chris


Bernie Deitrick

Push the button
 
Chris,

You are correct. It is Excel standard behavior that when you are in Edit mode, you cannot run a
macro.

HTH,
Bernie
MS Excel MVP


"chris" wrote in message
...
Dear all,

I have currently made an Excel form that includes some radio bullets and
combo boxes. The functions behind the VBA controls work without any problems,
but the control don't always react.
When I have written some text in a cell and I did not exit the cell it is
not possible to enable a control I first need to exit the cell before I can
enter a combo box or a radio bullet.
I know that this is probably standard Excel behaviour, but I would like to
know if there is a solution.

Thanks for your help.

Chris





All times are GMT +1. The time now is 08:15 AM.

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