Hello

I have a userform into which i would like to select US States from a USA map by clicking on the state.

I have a sheet with the USA map, with code that accepts the click on a state and display its Name.


I do not know how to integrate the userform and the Map.

I would like to:
1 - have a button on the userform that will display the sheet with the map.
2 - click the state on the sheet,
3 - re-display the userform with the state name I clicked on

My missing part is:
How to switch from my userform to the sheet, and after the click on the state, re-display the userform

thanks for any idea