Row Source problem

misterg

Board Regular
Joined
May 14, 2002
Messages
66
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
If you are minimising the workbooks in code try activating the workbook containing the code afterwards like this:

Code:
'   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
 

Forum statistics

Threads
1,144,444
Messages
5,724,391
Members
422,548
Latest member
Cuprian

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top