Home > Could Not > Could Not Set The Rowsource Property Member Not Found

Could Not Set The Rowsource Property Member Not Found

Set ws = sheets("Filter") 'Add this to see what the actual object name is of the new sheet MsgBox ws.codename 'This will tell you if sheet9 is the correct Excel Video How can I do this properly? DimrsAsDAO.Recordset WithMe Setrs=.RecordsetClone rs.FindFirst"[nest]='"&.nestcombo&"'" IfNotrs.EOFThen.Bookmark=rs.Bookmark With.[dataentrybird_id].Form.bird_idcombo .RowSource=_ "SELECT[bird_id]"&_ "FROM[tNBIRDS]"&_ "WHERE[nest]='"&Me.nestcombo&"'"&_ "ORDERBY[bird_id]" .Value=.ItemData(0) EndWith EndWith EndSub PS. I realized most of my problems were stemming from my trying to prevent my users from being able to unintentionally mess things up, while keeping the whole thing friendly to those Source

Already Tried: Try to rebuild all forms in 2010, but copied code from the previus versions of excel, insert msg in front of each precedure to make sure it isn't running Page 2 of 2 First 12 Jump to page: Results 11 to 13 of 13 Thread: User Forms - getting them to talk to Excel Thread Tools Show Printable Version Email Have a look at Application.Find to help with searching for text etc. I have printed them, and will be reviewing them throughout the day. http://www.mrexcel.com/forum/excel-questions/274408-add-userform-combobox-module.html

Register To Reply 02-01-2006,12:56 PM #12 Amber_D_Laws View Profile View Forum Posts Forum Contributor Join Date 12-30-2005 Location Mobile, AL Posts 102 Problem solved. Thanks a ton! I will look into it when I really get to that stage. Register To Reply 01-27-2006,06:35 PM #4 Amber_D_Laws View Profile View Forum Posts Forum Contributor Join Date 12-30-2005 Location Mobile, AL Posts 102 WOW!

Register To Reply 01-31-2006,05:50 PM #9 JakeyC Guest Re: User Forms - getting them to talk to Excel Application.Statusbar will change the message in the bottom left of the window. This didn't happen with Excel 2007 but only with Excel 2010. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Aug 2nd, 2007,05:40 PM #2 ageren Board Regular Join Date Jul 2007 Location istanbul Posts 60 UserForm1.ComboBox3.ListFillRange = "'Elasticity'!$B$" Instead of filling ComboBox1 located on Sheet1, I want to fill ComboBox3 located in UserForm1.

To know what the code name is look at the image link below. I am running into errors at the SourceData.Resize... Just click the sign up button to choose a username and then you can ask your own questions on the forum. https://social.msdn.microsoft.com/Forums/office/en-US/dd7a896a-9680-40b4-9d8b-6066cd524196/excel-200307-vs-2010-vba-issues-could-not-set-the-rowsource-property-unspecified-error?forum=exceldev Thursday, August 16, 2012 3:30 PM Reply | Quote 0 Sign in to vote Any luck with this bug?

Dim res as Variant res = application.Match(Textbox1.Text,Range("Sheet1!A:A"),0) if not iserror(res) then msgbox TextBox1.Text & " already exists" Textbox1.Text = "" exit sub End if Some additional sources of information: http://support.microsoft.com/default.aspx?kbid=161514 XL97: PST on Dec. 30th with the primary email address on your Experts Exchange account and tell us about yourself and your experience. Join our community for more solutions or to ask questions. Privacy Policy Support Terms of Use Register Help Remember Me?

It's a good workaround that gives us a breath. The basic problem with the error message you reported was indeed an incorrectly-named reference to a control located on the subform as NeoPa indicated. I got this code straight off of one of the sites Tom refered > me to, one of the microsoft sites no less. point of this > code.

Thanks, Amber Amber_D_Laws Wrote: > Thanks for the tip. this contact form With the input box you will have to set a small piece of VBA to populate the relevant cell and maybe force calculation if it is switched off. I have tried replacing '.' with '!' to no avail and have spent a long time reading other threads on the internet. I want to include the name > of a worksheet $$TEMP$$.

VB: Me.lstData.RowSource = "Sheet9" If Sheet9 is the code name for a worksheet you would use it without the quotes, but again I'm probably missing something here, but this whole code userformlistbox.xlsm 0 LVL 32 Overall: Level 32 MS Excel 31 VB Script 6 Message Active today Accepted Solution by:Rob Henson Rob Henson earned 300 total points ID: 402264832014-07-29 You can All rights reserved. have a peek here Invalid property valu VB: Set ws = sheets("sheet9") Last edited by Dave Edmonds; January 29th, 2016 at 04:12.

Invalid property value Thread Tools Show Printable Version Search Thread Advanced Search January 28th, 2016 #1 Bumble1290 View Profile View Forum Posts I agreed to these rules Join Date 2nd Results 1 to 6 of 6 Thread: Run-time error "380", Could not set the RowSource property. If you really do need separate forms, then perhaps use the Deactivate event of one Form to call .Show method of the next. 2.

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. ...text omitted...

And now it doesn't like the name bird_idcombo? So data loops from worksheet to userform, back to worksheet, then back to userform? you mean use the list box to populate a spare cell on the worksheet (say at the very bottom). No, create an account now.

You could have a very crude one that starts at "0% Completed..." then a quarter of the way through your code becomes "25% Completed..." etc. Attached Files Temp.DB.zip (966.2 KB, 65 views) Feb 28 '11 #13 reply Expert Mod 15k+ P: 29,924 NeoPa I didn't find out exactly why the compiler was having a specific problem You left out the parenthesis. Check This Out Am going to try and read and hopefully understand more about VBA.

Excel Video Tutorials / Excel Dashboards Reports Reply With Quote January 29th, 2016 #3 Bumble1290 View Profile View Forum Posts I agreed to these rules Join Date 2nd December 2015 Posts See ya' soon, and take care, Amber Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 Feb 28 '11 #12 reply P: 26 Elizabeth Mitte Here is a simple version of my database with the form in it. You would use: VB: Set ws = Sheet1 No quotes needed and that would be the proper syntax.