Hi..
This is my first question,thanks for your attention
I want that ,during a VBA macro execution, the user could select a cell by hand ,then the value of this cell should be changed by the pression of different buttons on a userform, that was previously activated and repainted over the worksheet,so both are visible.
In this scenario I can't do anything with the worksheet,and with menu,the visible" layer" under the userform is freezed , or I should say locked ,because clicking on it makes an audible ring.
Is normal in this condition or depends about something in the code(that i'll be glad to copy here ,if related)?
How to have the worksheet responding to selections by mouse/keyboard without stopping the running macro?
Thanks ,expecially because my poor english can lead to lack of clearness.
This is my first question,thanks for your attention
I want that ,during a VBA macro execution, the user could select a cell by hand ,then the value of this cell should be changed by the pression of different buttons on a userform, that was previously activated and repainted over the worksheet,so both are visible.
In this scenario I can't do anything with the worksheet,and with menu,the visible" layer" under the userform is freezed , or I should say locked ,because clicking on it makes an audible ring.
Is normal in this condition or depends about something in the code(that i'll be glad to copy here ,if related)?
How to have the worksheet responding to selections by mouse/keyboard without stopping the running macro?
Thanks ,expecially because my poor english can lead to lack of clearness.