user form in excel

Good Morning, I wonder if you can advise please? I have an excel workbook which has >100 sheets (one for each persons information) which is controlled from a User Form. All the sheets are hidden until the user clicks on their button on the user form. This function works well and as it is in a...

Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box The sheet name...

I have a data base that I need to be able to automatically archive and remove lines when there are a certain amount of out of date dates. My thought process is to run a check that will detect the out of date dates, select the entire line and remove the data to a holding page until the details...

Dear Experts, Thanks for all your suggestions and inputs you have provided me for different queries I have posted on this forum. Request your help again for an enhancement feature, to include in my existing user form. I have attached screen shot of user form, which is to input data for service...

Hi, I'm wondering could VBA user form have the input box function as the picture show below? My purpose is to make a user form with 2 parts which could submit the data into multiple rows. example: row 1 = form Part A + Part B1 row 2 = form Part A + Part B2 row 3 = form Part A + Part B3...etc...

I have another issue where I'm stumped, I've used this same code on 5 different other forms and it performs as it should on them but on my current worksheet, it continues to "overwrite" the previous data instead of moving to the next line in the table. My code is as follows: On Error...

Hi, Location Furniture Item Vendor I created a user form in excel its working fine but the problem now is in each location there can be same type of different items of furniture say for example - Look at the example below: Location Furniture Count of furniture Item...