vba & code

Here's my setup: Workbook = WORK_ORDERS Worksheet = DATABASE Worksheet = SALES_SHEET_MASTER DATABASE has the following columns ITEM_NO ACCEPT DECLINE HOURS COMPLAINT_1 COMPLAINT_2 CAUSE CORRECTION SALES_SHEET_MASTER has a much less organized layout because the spreadsheet is being used as a...

Hello I have a list box inside a user form and I want to display the total amount in the list box in a text box or label For this I used the following code Private Sub sum_subjects() Dim total_v As Double For i = 0 To ListBox1.ListCount - 1 total_v = total_v + Val(ListBox1.Column(5...

Hello everyone, I'm still learning VBA and all it can do. And I have really appreciated the help I have received on this forum through the years. :) My current question is coding for automatically sorting an excel table (as data is entered) when a cell from a specific column contains specific...

Hi all I'm new on this forum, but have a little experience with Excel VBA coding. I struggle to find out what is causing a certain behaviour. When running the code below, which is started with a Button on sheet 1, the graphs on sheet 2 are changed. ActiveWorkbook.SaveAs fileName:= _...

Hi guys, Need help making changes to a code I have had previously put together for me. The code below splits a .txt file into multiple .csv files and archives the original .txt file into a folder. I need it to also replace all the "," characters in the .csv files it generates with ";"...

Hi guys, Need urgent help please. We require a VBA code that can be assigned to a macro button that does the following: 1. When pressed brings up a dialog window to select a folder containing all .csv files 2. Code goes through entire folder and converts all .csv files to .txt files 3. Code...

Hello, So I am new to VBA coding. I wanted to dynamically unhide and hide the column based on the value in my cell C3. My problem is the first 1 is working, but when i choose another category it will hide all or other columns that I don't want to hide. If I type TestA I wanted to hide my...

I work from both Microsoft and MacOS platforms. I am in need of a macro that will add a checkmark to a cell easily. I have tried using code from a previous request "Using VBA in EXCEL to add a checkmark to a cell" but it will not work on my new Microsoft machine and I am not sure it will work on...

Hi, i'm I'm trying to modify the code in VBA so that it does the same as in the other cases, only one line below in my sheet "Prítomnosť1" and writes it Let Worksheets("Záznam").Cells(f, 11).Value = I'm doing something wrong but I can't figure out what, can somebody help me ? Sub zaznam()...

Hello, I'm a very new (I mean literally an hour) in using VBA and Macros and I'm trying to write my very first if statement. The issue is that when I try on a single cell everything is fine, but I am trying to apply it to the whole column! More specifically - if something occurs in column A then...

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

I have a worksheet that has multiple dropdowns. There is one column (B6:B35) that has several values in the dropdown but if a specific value is selected in one cell I need to force 3 other cells in the same row to be set to a specific value. Example If B6 is changed to "Cloud Provider", I need...

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

Hi, I have 3 worksheets in a workbook. Spreadsheets named EXCEL, PDF and CSV in the TEMPLATE workbook. ( different details on each tab). I want to save off the Excel tab as its own excel workbook and the name based on the value in B1. I would like to save to the C Drive in a folder called Macro...

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

Is there a way to change the naming of the JPG from Capture.JPG to whatever text is in cell V3 and then .JPG?

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

Hi since i updated my code the error 70 "Permission Denied" keeps me from activating my search form. Const SEARCH_BLANK As String = "[BLANK]" Sub FilterData() Dim ws As Worksheet Dim i As Long Dim lastRow As Long Dim matchCriteria As Boolean ' Change "Sheet1" to the...

I am extremely new to VBA, so I hope that this is easy to do and I am just missing the obvious. I have code that defines a named range as the active row, and another that does the same for the active column. How to I combine the two into one sub so that I can automatically calculate active row...

I am new in learning Userform VBA code, I created a Userform having labels,textbox and multipage with ClsTabMenu,Module1 and Userform Codes but on clicking run to load on VBA home, it displayed Run-time error "91" Object Variable or With block variable not set find codes below clsTabMenu...