vba userform

I'm quite new to VBA and have been playing with this for days. It's a little hard to explain: There are 3 sets of option buttons on a userform, which column the data is entered into is dependant on the permutation of these results. However, I can't work out how to look for the next empty row...

hi i am new to vba i want to Update cells via a user form. user enter data in form and update in some cells like c5, c6, d5, d6, e6. e7. one more thing i want to show some data from the sheet on a user form. please help me... below given is code for 1st user form. Option ExplicitPrivate Sub...

I have this code, not sure how to post in the correct code format, but here is what i am looking to do. I am looking to take this code, make it so that I can have 4 checkboxes in my Userform. when any one of those 4 check boxes are selected it will attach a certain sheet (named the same as the...

Hello All, I have this code that searches for the selection in a ComboBox in a specific column then "copy & pastes" a cell on the same row into a TextBox (3 cells & 3 text boxes), I'm trying to get each found item on a new line in the text box. The code below works to do this using arrays, but...

Hi All, Bascially I have created a UserForm that has a ComboBox and depending on the number selected I want it to show that number of Labels/TextBoxes... so if I select "0" nothing is shown, if I select "1" one set of Labels/TextBoxes is shown, select "2" and two sets of Labels/TextBoxes are...

I have a VBA userform with a grid of numbers, each of which needs its own "click" action. For example: [0 1 1 4 0 1 0] [2 0 0 0 0 2 0] These numbers are updated through other VBA functions. How can I create click actions for each of these numbers? Right now this data is created as lables on...

Hi there, I'm working a lot with userforms at the moment, and want them to be as user friendly as possible. I'm having difficulty with tabbing, as in, if the user tabs the cursor doesn't neccesarily jump to the next box, rather, it jumps to the box in the order i created them which isn't the...

I have workbook that has a tab for each week in a month. I have used a VBA userform with a multiselect listbox to allow the user to select multiple worksheets to roll-up into a summary worksheet. My problem is writting the sum formula to accept the listbox's array. Here is my code. I have used...

Hello, I have a userform within a spreadsheet which, when loaded, uses vba to create a label (code below). I would like to add some code to this newly formed label, so that when it is clicked, the backcolor of the label changes to black i.e. RGB(0,0,0). Code to create the label within the...