Invalid property value.” error when open not editable xls file up vote 0 down vote favorite I'm getting a “Run-time error '380': Could not set the ListIndex property. However, the reverse doesn't hold true. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. It also pops up when the word entered doesn't match, like it is supposed to.I have MatchRequired set to True, because I want an error message to come up, but with Source
It takes just 2 minutes to sign up (and it's free!). Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? donwb "JLGWhiz" <> wrote in message news:... > If your ListBox is MultiSelect you can't use ListIndex. For example, let's say we have an Occupied unit that is scheduled to move out on 5/15/08.
asked 5 years ago viewed 6294 times active 5 years ago Related 1Need List Box values to be displayed in cell after clicked1Require selection - Excel VBA List Box0Can't transfer list Parents disagree on type of music for toddler's listening Why do Latin nouns (like cena, -ae) include two forms? "Shields at 10% one more hit and..." What? Unable to get the SpecialCells property of the Range class. With ListBox1 ListCount = .ListCount .AddItem gateway.Value .List(ListCount, 1) = dueDate.Value End With excel vba listbox share|improve this question edited Jan 28 at 11:07 asked Jan 28 at 10:33 peetman 717
I guess it was made long time ago. Invalid Property Value.>> I have used this code in another project and it runs fine. There are 16 fields loaded into dReservData. Frankly, I have no clue as to why I'm getting it on just this one statement. –BillD Jul 6 '14 at 6:44 add a comment| 1 Answer 1 active oldest votes
What is the proper usage of "identically zero"? Excel Vba Run Time Error 380 Advertisements Latest Threads Steam Link - £15.99 Ian posted Dec 24, 2016 at 10:35 AM WCG Stats Saturday 24 December 2016 WCG Stats posted Dec 24, 2016 at 8:00 AM HAPPY What is the truth about 1.5V "lithium" cells The female equivalent of "don't break my balls" Measuring Water with a Holey Cube more hot questions question feed lang-vb about us tour There are ways to do this using the Windows API, but it quite complicated to do and probably not worth the effort for the effect.
I don't really understand what you mean here - I've never had a problem setting the ListIndex property to the row I need selected before. http://stackoverflow.com/questions/35058954/could-not-set-the-list-property More About Us... Excel Vba Combobox Runtime Error 380 Invalid Property Value Please help, I would greatly appreciate any help anyone could provide. Runtime Error 380 Could Not Set The Value Property Invalid Property Value I do have a recognition to know when the counter reaches the last index.
current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. this contact form Would presence of MANPADS ground the entire airline industry? How can I tell whether a generator was just-started? Not the answer you're looking for? Excel Vba Runtime Error 380 Invalid Property Value
What does this symbol of a car balancing on two wheels mean? How to replace not found reference "??" in an another constant e.g "REF"? Here is the FAQ for this forum. + Reply to Thread Results 1 to 7 of 7 Cannot set Listindex property! have a peek here Were Palpatine or Vader ever congratulatory or nice to any of their subordinates?
When the ListBox's dimensions are changed externally, it is redrawn. Runtime Error 380 Could Not Set The Rowsource Property Not the answer you're looking for? Law case title convention: Why sometimes not "Plaintiff v.
Does the ListIndex forcefully have to begin at 0? I couldn't find anything. The problem I have is that the listindex returned from selecting an item in the listbox returns the same number for an entry of the same value in the first bound Could Not Set The Rowsource Property. Invalid Property Value. How to respond to a ridiculous request from a senior colleague?
What is this picture in Thrawn's study of? Browse other questions tagged excel excel-vba combobox or ask your own question. A Page of Puzzling Why did Sansa refuse to leave with Sandor Cleagane (Hound) during the Battle of Blackwater? Check This Out View 9 Replies View Related Enable Property Of Textbox Oct 7, 2009 With Sheet4ActiveSheet.Unprotect Key.Rows("13:252").EntireRow.Hidden = FalseIf Me.OptionButton1.Value = True Then.Range("MyMrate").Range(Cells(Val(Me.TextBox1), 1), Cells(Val(Me.ComboBox1), 1)).Value = .OLEObjects("TextBox" & i).Object.Text.Range("MyMcash").Range(Cells(Val(Me.TextBox1), 1), Cells(Val(Me.ComboBox1), 1)).Value
can use 'On error resume next' Share Share this post on Digg Del.icio.us Technorati Twitter Regards, Gautam S Reply With Quote Dec 16th, 2010,03:25 AM #4 dave3009 Board Regular Join Date Browse other questions tagged excel vba or ask your own question.