R
Rich Cooper
I have a map of the united states on a tab in my workbook I ahve another
tab that has information about doctors. It tells the doctors name and gives
some demographic information about them. Each state is it's own shape.
When i click on that shape i want to be able to do some specific things
based on what state you clicked on. For example if i were to click on new
york i want it to msgbox the user saying new york, change the color of the
state and then bring you to a design template and populate it with new york
doctors only. So i would have 3 sheets in this excel workbook. A map
sheet, data sheet and this view sheet. The view sheet is shows data one you
ahve clicked a state. So when you click new york it would show doctors in
new york, if you clicked vermont it would show doctors in vermont. If
anyone could help i would greatly appreciate it.
tab that has information about doctors. It tells the doctors name and gives
some demographic information about them. Each state is it's own shape.
When i click on that shape i want to be able to do some specific things
based on what state you clicked on. For example if i were to click on new
york i want it to msgbox the user saying new york, change the color of the
state and then bring you to a design template and populate it with new york
doctors only. So i would have 3 sheets in this excel workbook. A map
sheet, data sheet and this view sheet. The view sheet is shows data one you
ahve clicked a state. So when you click new york it would show doctors in
new york, if you clicked vermont it would show doctors in vermont. If
anyone could help i would greatly appreciate it.