I have used this site to learn about writing macros from scratch and have found it fantastic but the for the first time I'm having a problem for which I can find no answer which probably means its me being dumb!
I have a userform with a listbox that can be run from any of several dozen worksheets. It should load its contents from a range on the active sheet using the RowSource property. It works the first time but if I then run the userform from another sheet it still contains the data from the first sheet and doesn't update with the new data from the new sheet.
The form is run from a macro assigned to a button on the sheet using UserForm2.Show and closed again using UserForm2.Hide assigned to the cancel button.
The source range is AN4:AN8
Any help would be greatly appreciated and bring an end to alot of head scratching.
I have a userform with a listbox that can be run from any of several dozen worksheets. It should load its contents from a range on the active sheet using the RowSource property. It works the first time but if I then run the userform from another sheet it still contains the data from the first sheet and doesn't update with the new data from the new sheet.
The form is run from a macro assigned to a button on the sheet using UserForm2.Show and closed again using UserForm2.Hide assigned to the cancel button.
The source range is AN4:AN8
Any help would be greatly appreciated and bring an end to alot of head scratching.