VBA Select Cells with Mouse mid code

[decadence]

Hi, Is there a way to select cells mid macro with the mouse that doesn't use the input box to show what is being selected? but also wait to resume code until cell is clicked?

 

[Rick Rothstein]

Hi, Is there a way to select cells mid macro with the mouse that doesn't use the input box to show what is being selected? but also wait to resume code until cell is clicked?

I don't know of a way to do it that way, but if I did, I would caution you not to use it. Reacting immediately to user clicks directly penalizes the user if he/she mistakenly clicks the wrong cell(s) when making their selection. With the InputBox method, the user can click away to their hearts content until they are sure the correct cell or cells have been selected, then, and only then, would they signal to your program they are ready by clicking the OK button.