Row Source problem

[misterg]

Good afternoon,

Im having a spot of bother with this point:

I have a workbook open(but minimised) with a userform taking inputs via text boxes.
There is a range defined on sheet 1 called Products, which i need a combobox on the userform to refer to.
This works fine using Row Source.

However, if another workbook is open in excel at the same time, sometimes the combobox doesnt display anything, as if its looking for the range Products on another workbook.

How do i tie the Row Source into the one workbook and just make it look there?
Ive tried adding the name of the sheet in the Row Source, but its Invalid, apparently!
HELP!!!!

Many thanks

G

 

[Andrew Poulsom]

If you are minimising the workbooks in code try activating the workbook containing the code afterwards like this:

'   Minimise all open workbooks
    For Each Window In Windows
        On Error Resume Next
        Window.WindowState = xlMinimized
        On Error GoTo 0
    Next Window
'   Activate this workbook (minimising activates next open workbook)
    ThisWorkBook.Activate