Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Error 380: could not set the rowsource property. invalid property value when changing the rowsource property

Posted on 2008-11-07
1
Medium Priority
?
2,255 Views
Last Modified: 2013-12-26
Hi,

VBA/Excel issue

I am encountering an issue where I get the error "could not set the rowsource property. invalid property value".

I have a listbox and change the elements it refers to depending on what options a user selects.

The first time I set the RowSource property, it works perfectly. If I add items to the referred worksheet and update the Rowsource property everything is fine. When I go to change it after adding something to the original list, then I get the error.

For example, I cannot change the Rowsource property from "Element1!G122:I124"
to "Element3!Q122:S128" - get the error.

In the watch window I try to forcably change it to "Element1!G122:I123" (ie. referring to one less row - a minor change), and the debugger gives me the same error. However I can change it to "" (Null)

Any ideas?

Thanks

Greg
0
Comment
Question by:gbergsma
1 Comment
 

Accepted Solution

by:
gbergsma earned 0 total points
ID: 22909630
I have no idea why this works, but when I create an object and set it to the form, and then set the rowsource property, it works

What the?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question