Posted to microsoft.public.excel.programming

DKS

external usenet poster

Posts: 103

Refreshing ROWSOURCE

For one of my user-forms, I have a combo-box. The rowsource property
contains a formula using OFFSET function that refers to existing areas in the
existing workbook.

When the form is displayed, the ROWSOURCE works correctly, and the drop-down
is correctly created. Neverthless, if the cells (that are part of the
ROWSOURCE formula) change, the valid values for the combo-box are not
refreshed.

Is there a way to easily refresh the contents programatically?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RowSource	Patrick Simonds	Excel Programming	1	August 5th 06 01:25 AM
help with rowsource	GMet	Excel Programming	4	September 24th 04 02:30 PM
combobox rowsource	Newbie	Excel Programming	1	September 8th 04 12:21 PM
Using IF, Then with rowsource?	CAA[_23_]	Excel Programming	8	April 4th 04 08:56 PM
Is refreshing listbox rowsource in listbox click event possible?	Jeremy Gollehon[_2_]	Excel Programming	4	September 25th 03 06:45 PM

All times are GMT +1. The time now is 07:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us