I created an inputbox that takes the value entered and multiplies it by each of the percentage totals in cells D45:D47.
Although the inputbox works just fine, I need it to populate when I click on cells D45:D47. Originally, I tried referencing the inputbox in the subroutine (ByVal Target As Range), but it doesn’t recognize the inputbox (please see attached).
Is there a way to reference the inputbox to show when I click on cells D45:D47 or do I have to create a separate userform and then reference it back in? I also tried creating a userform, but ran into a number of issues with that too. I feel like I'm spinning in the mud.
Any and all help would be appreciated.
Bookmarks