Need help modifing userform macro to account for textboxes and combo boxes

[Pimp_mentality]

Good day all,

As the topic states I look like some assistance modifying the attached macro to recognises both TextBoxes and ComboBoxes.

A colleagues on this forum wrote the attached Macro for me to input volumes of data from a userform into a spread sheet where the data would be stored. The initial user form utilized solely TextBoxes for data input. however since I have utilised ComboBoxes in my user forms as they allow for the option to have dropdowns. but now the macro wont run.

Please have a look and advise as how i can modify the attached code to account for textboxes as well as ComboBoxes.

[AlphaFrog]

You originally had 8 textboxes; TextBox1, TextBox2... TextBox8. Which of those textboxes were replaced by Comboboxes and what are the combobox control names?

[mikerickson]

The first bit is easy enough.

Please Login or Register  to view this content.

In regards to the second bit, it depends on how your controls are named. Since you only have 8 controls, you could do

Please Login or Register  to view this content.

[Pimp_mentality]

You originally had 8 textboxes; TextBox1, TextBox2... TextBox8. Which of those textboxes were replaced by Comboboxes and what are the combobox control names?

well for this particular Userform textbox 8 was replaced with a ComboBox, however I have several other userforms, utilizing the same coding, which have different textboxes replaced by ComboBoxes (not necessarily in sequential order.

[Pimp_mentality]

The first bit is easy enough.

Please Login or Register  to view this content.

In regards to the second bit, it depends on how your controls are named. Since you only have 8 controls, you could do

Please Login or Register  to view this content.

Can I assume that in the first line of code was meant to be If Typename(t) = "TextBox" or Typename(t) = "ComboBox" Then

vs

If Typename(t) = "TextBox" or Typename(t) - "ComboBox" Then

Please take note of the = and - sign before combobox

[mikerickson]

Yes, the idea was to add a second conditional and the AND operator.

[Pimp_mentality]

Good day mikerickson

I tried the attached code to my project but still getting debugging errors. I have attached a stripped down version of the work sheet so you can see what I wanted. the UserForm under scrutiny is titled StuPerInfoFom

[bakerman2]

Please Login or Register  to view this content.