AcousticalConsultant
Technical User
Hello,
I am trying to make an interactive macro where the user is able to select cells while a userform is prompting him to do so. Similar to the way that Excel allows you to create a graph. When entering data, you can click and drag your mouse over the desired region and the formula will automatically appear in the corresponding textbox.
When I load a userform, I am not able to access the spreadsheet behind it. Is there a way to allow for access to both?
Thanks!
I am trying to make an interactive macro where the user is able to select cells while a userform is prompting him to do so. Similar to the way that Excel allows you to create a graph. When entering data, you can click and drag your mouse over the desired region and the formula will automatically appear in the corresponding textbox.
When I load a userform, I am not able to access the spreadsheet behind it. Is there a way to allow for access to both?
Thanks!