The idea is that there is a userform which is comprised of two combo boxes. The first combobox fill the second combobox on dropbuttonclick(), and that works just fine. Based on the user's selection the userform then populates several cells, that are used in formulas and then hides the userform. I also need to come up with a line of code to recalculate the values of the formulas. Application.refresh? or .update?
My major problem is that the cells referenced will not populate when the commandbutton is clicked, but the userform does close so the event is being triggered.
Please Login or Register to view this content.
Bookmarks