G
Guest
I am trying to create a macro where apon clicking a commandbutton in a user
form assigned to a specific defintion it will go directly to a specific cell
within a specific range. For example if the user named Brian Monaghan clicks
on the button for the definiton of analytics I want him to be taken to the
Analytics cell for the range assigned the name of "Brian_Monaghan" and not be
able to click on any other range in the worksheet titled
Employee_Tasks_Tracker_MOCK3. After I do that do I need to create a nested
loop to have this done for every single employee or do I just have to
manually enter all of them in there. I apologize if this question is
confusing I am a novice at Macros and am having to learn on the fly.
form assigned to a specific defintion it will go directly to a specific cell
within a specific range. For example if the user named Brian Monaghan clicks
on the button for the definiton of analytics I want him to be taken to the
Analytics cell for the range assigned the name of "Brian_Monaghan" and not be
able to click on any other range in the worksheet titled
Employee_Tasks_Tracker_MOCK3. After I do that do I need to create a nested
loop to have this done for every single employee or do I just have to
manually enter all of them in there. I apologize if this question is
confusing I am a novice at Macros and am having to learn on the fly.