userform

Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...

Is it possible to recall the value selected (highlighted blue) in a userform listbox when form is shown again. Below code uses arrays to show subfolders in a listbox. Option Explicit Private Sub UserForm_Initialize() Dim file_system As Object, sub_folder As Object Dim main_folder As String...

I have a column B that contains the date, and a column "i" that contains incoming values, a column" j "that contains spent values, and a textbox1 contains a date and a Textbox 2 is required to show the result of collecting column cells, "i". that are smaller than the date in textbox 1, as well...

I am wanting to have a userform which brings in my information from the user and then outputs it to a spread sheet but I can't figure out how to get it to output in 2 decimal places if the user does not put in the value with any decimal places. I want it to always output to 2 decimals regardless...

I've got a user form I want to use to determine how to run a macro: Private Sub UserForm_Initialize() 'Reset the form radiotempl1.Value = False radiotempl2.Value = False datatype.Clear With datatype .AddItem "Public" .AddItem "Private" End With radiotier1.Value = False radiotier2.Value...

Hello, I have a user form like mentioned above and the form needs a searching feature that searches based on certain column text, and then being able to update certain values from selected combobox text & text box values. The search box and command button s are Command button 4 = "search"...

Hi, I have a spreadsheet containing a list of products and Promotions. Each product can have multiple promotions, and one promotion can be found in different products (many-to-many). This spreadsheet is updated constantly. I created a UserForm with a dropdown list containing unique products...

Hi, I'm trying to work out if its possible to generate a number of labels from 1-68 labels. each label has unique data based off of a data sheet. ill attach an image that displays the label and where certain information needs to populate. The Number at the top comes from the data sheet...

I have a Sub Routine to help users add a new tab to a spreadsheet. It starts by opening a userform where they enter the name of the new tab. The userform then closes and the VBA then searches to see if there is already a tab with that name - if there is the user gets a message to say it already...

Thanks for any help , it is needed, i have searched and tried to find some code to make my own but have no luck so i am looking to this forum yet again for help. So what i am looking to do is to simply copy values of a cell and paste the value in another cell on a separate work sheet using...

I'm in the process of making a training tracker for multiple office sections. I was able to create a data entry form that will send an individual's information to the sheet for their respective section. However, the only solution I could think of to easily update old information without making a...

Hi all, I have a UserForm that Loads and Shows when the Workbook is opened. The User is given the current date setting that is saved to a worksheet cell on each use. Ths User is then given a choice to use a different date Yes or No. If the User chooses Yes, then a Listbox on the UserForm is...

Hello, I have a excel workbook that I have created that needs a specific code for userform combobox. The question/ problem, the combobox has a selection which is automatically populated in the initialization. In combobox the selection is: 1. clamp install 2. damaged clamp With that...

Hello all I really need your help as the topic title says I need to find the minimum, maximum, less than 4000 among the selected listbox items. AB1EmployeeSalary2Gilmore34403Stone67804Horton102445Rice54326McDaniel205447Fowler123228Paul54409Burns765610Robertson4568 I already have a form, but I...

Hi I have a UserForm that has a filter Combobox that filters different criteria. and that includes "Year" and a TextBox which will be the search box. and a listbox that will show result Note: "Year" is in separate column ("T") the search box is working fine for other criteria, except for...

Hi all, I have a number of similarly named user forms that are called based on the value in a cell. I am trying to find a more efficient way to call the user forms without having to add additional elseifs to the code everytime I add a few more. I thought I had the right idea, but perhaps I...

Hi All, Ive searched and searched and cant find an answer to my query. If it has been answered already please point me in the right direction. I have a shared excel workbook where multiple staff could be in at the same time. Staff input and update data via a userform. To populate the excel...

Hey Guys, i have an Workbook with 5 Sheets where you can add Data while Using a Userform. The Data begins in each Sheet in row 10, since i nead the rows above 10 for my interface. I have also an Mastersheet, where the Data from these specific Sheets should be copied and should be edited if...

Hello all! I have been reading posts here and online and i'm not sure which path to try. I have a Userform with many buttons that lead to various "Orderforms" - 1 per vendor. What my macro does is capture the info from each vendor onto 1 "Summary" Sheet and 1 "customer info" sheet. (I guess...

Hello, I'm very new to VBA and I'm trying to work through a project but have gotten stuck. I'm trying to have a comment entered into cell I13 and then any subsequent comments to be entered in the row below and so on. So far this is what I have, but it stops working after the second comment has...