vba excel

I have data in sheet Check of the excel file .test file and expected result Bot_Container_Size Bot_Container_Height Bot_Container_Type Bot_Remarks_By_ContainerInfo Bot_Website_Gross_Weight_ConvertUnit Bot_PickUp_Place ;20':20FT;40'GP:40FT;40'HC:40FT Small ;20':Not Applicable;40'GP:OK to...

I have created a userform to submit data to the respective cells based on vba code I found on the forum that will help me and i modifies it. But it was not working as intended. I want to match a date in textbox1 from the userform to column G, if the date is not found, add a new row and populate...

This is really messed up. Please help me with a workaround that works. I'm completely disabled. I have a workbook called Journal.xlsm and another workbook named TokenHandling.xlsm. TokenHandling.xlsm is stored on my OneDrive but I access it via my local OneDrive folder on my harddrive...

Hey Guys, I have been investigating for a while an issue, I have a userform with multipage (Page1, page2, Page3) . The 3 pages have command buttons and labels, but only the page1 keeps the memory of the labels as "Completed", when I try to run others codes in comandbutton in page2, not sure...

1.) While the import file will have many rows maybe more than 5000 rows, I want to cut 1-100 rows and then 101-201 loop file until to 5000 rows after that export to another excel by separate sheets 1-100, 101-201 .. next to ... Sub test() Sheet60.Range("A1:BX100").Copy Workbooks.Add...

Hello everyone, A simple one no doubt........I have inherited the below code and would like to amend to include a statement at the beginning to echo the following: IF CELL Z1 ON SHEET 6 IS BLANK THEN END SUB, OTHERWISE DO ALL THE BELOW. Can anyone advise please? Thanks very much in advance...

I use this code to search in the list box and it works well, but when I search in the first column in the list box for a number, for example 1, 2 or 3, it gives me all the numbers that contain these numbers, so how can I make it show me in the list box only the specified number in the search...

Good Morning i have got a user form whereby it inputs the total number of days between the two dates selected from a calendar, however, i would like to convert this into the hours instead of the total days Sub Calculate_Days() Me.TextBox7 = "" If Me.TextBox2.Value <> "" And...

Hello i've got a Makro which calls a link and it download a cvs file. This link needs 6 variables to work, example: h t t p s : //blabla.com/ startdate=var1 & starthour=var2 & startmin=var3 .. etc would result in h t t p s : //blabla.com/ startdate=2023/01/06 & starthour=23 & startmin=30.. etc...

Hi all, I am trying to merge cells using macro, but it works quite oddly and I cannot pick the mistake in code. Code: Sub testee() Application.DisplayAlerts = False Dim rng As Range MergeCells: For Each rng In Selection If rng.Value = rng.Offset(1, 0).Value...

Can anyone help me to solve this syntax of of adding file path to TEXTBOX This is my UI form

Hello All, looking for some guidance on this problem I am stuck on. I am sure it is doable just can't figure it out at the moment and my vba skills are not the best. Below is a table and I am looking to subtract until amount is zero with a condition to not go under $25.50 in Column B. So...

I wrote the following code which creates a 3 by 3 table and then sorts the columns from smallest to biggest depending on the values in row 1 (second row). For some reason, with the values below I get to a point where the code does "If( 2>1) Then" but the code then says its FALSE and skips, I...

At present I have a code to select and delete one row from a listbox and the corresponding sheet. However i need to modify it to select multiple rows from the listbox and delete them from listbox as well as the corresponding data rows from the sheet. please help to modify: i am using the...

hi i need to find a way to create multiple txt files from an excel, as shown in the picture. In detail i need to create a file txt with the name "sez-A1" and another "sez-A2" and so on. inside the txt i need to have the numbers of the 2 columns x and y from the excel

Hello! I am new to VBA excel and i have a homework where i have years from 2000 to 2030 and i have to find Advent 1st for each year. Can anyone help with this? Thank you!

I have designed a calender with a to do list in which each row is assigned for to do list serial no. and columns have dates. when a cell is clicked it opens a userform1 with 4-5 textboxes/ comboboxes, which now at present is filled manually by selecting the particular row and date column. The...

I have a listbox which is filled with data transferred from textboxes in the userform and not from sheet. The listbox has multiple rows and columns. I have also added a code to delete a row before final saving of the data to excel sheet. Hence if I try to give / add a row number through a...

I want to build a data base using a userform1 having say 4 textboxes to input data textbox1 - Name textbox2 - address textbox3 - Start date textbox4 - end date the sheet1 where data will be saved will have columnsA as Name, ColumnB as Address, ColumnC as Date. I want to capture data in sheet1...

I do a LOT of scheduling people at my job. Kronos spits a nasty excel sheet with 1000's of rows and about 40 columns. I've got created enough macros to where it fine tunes it to what you see below BUT I would like to do a few more things to really make it so I can print these schedules for staff...