I have a variable in my macro. and then i have a userform that uses the same variable. i want the item picked in the userform to be added to the variable and called out again from the macro....but it's not working as intended. the item picked from the userform does not show up when i recall the variable from the macro. i tried declaring it as public in the decleration section and i also tried declaring it as global. but neither one of these methods works.
here is my code from the macro
and here is my code in the userform
is there a way to get this variable to add items from the userform and show it in the macro when i call the variable back?
Bookmarks