| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to change the Input Range of a Form Control programmatically?
Is it possible to change the input range of a drop down box Form
Control programmatically? I have a list of categories for user selection. The categories will be obtained from a database through ODBC. The may be changed from time to time. How can I change the input range of the drop down box? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to change the Input Range of a Form Control programmatically?
dchow
The only way I can see to do it is to select the shape Dim shp as Shape Set shp = Sheet1.Shapes(1) shp.Select Selection.ListFillRange = "A1:A10" -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "dchow" wrote in message ... Is it possible to change the input range of a drop down box Form Control programmatically? I have a list of categories for user selection. The categories will be obtained from a database through ODBC. The may be changed from time to time. How can I change the input range of the drop down box? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to change the Input Range of a Form Control programmatically?
Thanks. That would work.
I took a different approach. I assigned a named range to the input range. Then I can change the named range. On Tue, 18 Nov 2003 14:06:50 -0600, "Dick Kusleika" wrote: dchow The only way I can see to do it is to select the shape Dim shp as Shape Set shp = Sheet1.Shapes(1) shp.Select Selection.ListFillRange = "A1:A10" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Is it possible to change the Input Range of a Form Control programmatically?
That's a great idea. Thanks for posting the solution.
-- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "dchow" wrote in message ... Thanks. That would work. I took a different approach. I assigned a named range to the input range. Then I can change the named range. On Tue, 18 Nov 2003 14:06:50 -0600, "Dick Kusleika" wrote: dchow The only way I can see to do it is to select the shape Dim shp as Shape Set shp = Sheet1.Shapes(1) shp.Select Selection.ListFillRange = "A1:A10" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to add rows to a range using input form | Excel Worksheet Functions | |||
| How can i change the size of a form control check box? | Excel Discussion (Misc queries) | |||
| Coping Format Control input range to other picklists - HELP!! | Excel Discussion (Misc queries) | |||
| trying to programmatically change chart data range with vb.net | Charts and Charting in Excel | |||
| Is it possible to create a dynamic range in CONTROL TOOLBOX (form) | Excel Discussion (Misc queries) | |||
Linear Mode
