Having Trouble Getting My Userform to Populate the Corresponding Excel Spreadsheet...

Hello: My name is Mich and I'm new to the group and I'm having an issue wth userform that I created that needs to feed data to an Excel spreadshee within the same woorkbook. I have a user form that requires our engineering team to submit to m ...

Message posted on the January 26th, 2012 - 12:56 PM ET

Moving up and down in a recordset to set userform values?

Hello, I am trying to populate a user form. I've got to where I can populate the userform fields using a recordset. Now I need the user to be able to get to the next record. I have a spin control on the form. When they press up or down, I need ...

Message posted on the September 14th, 2009 - 4:02 PM ET

populate some userform fields from access database

Hi All, I have a userform designed in excel, and I want to pull certain data from access database based on what I put in Student_ID field. Here is what I have so far for getting fields autopopulate based on what I put in Student_ID field... What I ...

Message posted on the November 9th, 2009 - 12:05 PM ET

Populate userform fields from access database

Hi All, I have a userform designed in excel, and I want to pull certain info from access database based on what I put in Student_ID field. Here is what I have so far for getting fields autopopulate based on what I put in Student_ID field... What I ...

Message posted on the November 6th, 2009 - 5:00 PM ET

UserForm Functionality

Hi all Just getting started on using UserForms and I'm liking what I see to date but have a question relating to their ability to operate as a search form. eg I would like to attach either a ControlField which a user can type whatever, lets say, ...

Message posted on the March 18th, 2011 - 8:12 AM ET

HELP Error: Trying to populate userform fields from access databas

Hi All, I have been struggling with this since long, I would appreciate if anyone can help me with getting this done. Basically I want to pull information from access database and populate my excel userform fields. For eg: If I input a Student Id ...

Message posted on the November 18th, 2009 - 2:37 PM ET

Populate userform combobox with option button

I have a simple userform with a combox and two option buttons. I would like to populate the combobox with a range if optionbutton1 is clicked and with another range if ob2 is clicked. I keep getting a "Run time error 13, type mismatch" ...

Message posted on the March 12th, 2009 - 5:28 AM ET

Populate ComboBox with Worksheet Names

I'm trying to populate a combobox in a userform with the names of the worksheets in my spreadsheet. I'm guessing I'll just need to put it in a userform_initialize statement with a For Each / Next loop, but am having trouble getting it to work. Any ...

Message posted on the November 17th, 2009 - 2:20 PM ET

ComboBox_Click event problem

I have a userform with several controls, one of which is a ComboBoxcontaining a list of names. When I select a name, subroutines (triggered by a ComboBox2_Click event) write data from the other controls to a spreadsheet, and then populate the ...

Message posted on the February 19th, 2009 - 9:05 PM ET

Stumped

I am stumped I have 2 routines the 1st ( Sub NextRow() ) is designed to take me to the first row which has the text "NoXXX", and it works fine. The 2nd routine is suppose to populate some TextBoxes on my UserForm and that is not ...

Message posted on the July 15th, 2009 - 4:40 PM ET

run-time error "381" - Could not set the List Property.

HI All, Please help. When I have the initial data and then run the script, the new value gets added to sheet2 correct without error. Then when I run the script again, I can't get Invest_Results userform to open - keep getting the following error: ...

Message posted on the February 24th, 2009 - 3:04 PM ET

Control Objects, and populating a Combo Box

Okay, I feel stupid. I need to be able to populate my combo box on a Vba custom userform. I can do it in Outlook Developer, and have figured it out in other developers easily, but I can't seem to do it in Vba editor without getting an error. I've ...

Message posted on the January 16th, 2009 - 4:34 PM ET

getting userform populate