excel vba

When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...

Hello all, Hope you can answer me I have been trying to add (clearcontents) to the code below that I have to copy from all sheets , clearcontents in master sheet before paste then paste , and everytime I am getting an error. to sum up what Im trying to do, copy contents from all sheets I have...

Hi Mr Excel Community, Please note I have a report and already have a macro that user be able to select multiple options in dropdown (Data Validation List) (Range C4) but now I need that everytime C4 changed the pivot table be updated with the values according the cell. I already have the code...

Hey Team, Device ID is not one of the Environ Variables Excel can access. Does anyone know how to lookup the Device ID of the computer you are currently working on using Excel VBA? I can find this variable myself by going to the about section in settings. however I am looking to reference this...

Hello everyone, I'm trying to automate specific tasks for our business and decided to rework our excel files. These excel files are used to upload specific products automatically. The base idea is to insert new rows with predefined values with checkboxes. I've already written some code which...

I recently started learning excel vba and so far I have relied heavily on the 'record macro' option for a lot of the formatting work. I've run into an issue, where I need the code to delete filtered rows (while keeping the headers), but the number of rows changes between sheets so I can't code...

Hi All, I am a novice in MS Access and VBA. I have written this code below to get a cumulative sum when a certain condition is satisfied. Calling this function in a Access query design. But it throws an error saying it contains a syntax error. Could anyone help rectify this? Public Function...

Hello I hope someone can help as I have been trying to figure this out for the last few days and getting nowhere. I have a complaints database that I have put together where the user fills in the userform with the details of the complaint and it gets put into the correct tab in the workbook...

I have a large workbook and the data within in needs to be filtered, I have datestamps in column A, these then need to be checked over all of coulmn A to see if there are any duplicates, if there are that duplicate then needs to be check against a value in column D, coulmn D contains a value...

Hi all, I am Currently working on a VBA that is able to open lots of workbooks from within a folder, each of these workbooks only has 1 work sheet, this work sheet will have multiple columns and 1000s of rows. I have an identifier in Row R that I use to separate the data. I then want excel to...

As this is my first message here and I don't see any place to make it, i Want to say Hello word and thanks for the amazing job all you are doing for teaching us. I have a question with a macro that works well, but I can't adapt it to improve what I want. I have a book that the first sheet is...

Hi guys, Very new to writing macros, I'm trying to automate the copy/paste/save of input and output data but I keep locking myself out of my Calculations workbook in the process :cry:! Context: I have the parent folder directory "...\Macro Test\" which contains 2 folders "Input" and "Output" and...

I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...

I am on office 2019 and I have been trying to automate my emails to an excel sheet as part of a Ticket System, I know absolutely zero VBA and have just been trying to cobble something together off of some old posts. All the different vba code I have tried keeps creating a copy of my workbook...

I have the following code that upon exit from Textbox87 first checks to make sure the user input a date in the correct format and that it is a valid date. Then it checks to see if it is a past date or a future date. I receive a Runtime Error 13 Type Mismatch error only if a nonsensical date...

I used the Excel"Scan-IT to Office app" to scan barcode . When I use my phone scan barcode,it always input to A1 cell or A2 cell...>A3>A4>A5..... I need the "barcode number" input to the userform "textbox(A)" not "sheets's cell(A1)" Like the picture I need the "barcode number(60106-04...

I want to automate a website but every time I received this error. and the website does not load completely and it redirects directly to Google Sub Amatti() Dim GC As New WebDriver GC.Start "chrome", "" GC.Get "Request Rejected" GC.Wait ("10")...

Hi all, When i press a button to run the VBA, previously it works but now shows the below message but my excel version is Microsoft 365. The VBA show error on here but i don't know why, would anyone help me? Thank you very much Below is my code: Dim wb As Workbook Dim wb2 As Workbook Dim...

I have a "Data" worksheet that I want users to be able to edit the data in this worksheet by using a Form (keep the data uniform). When the user opens the initial form (UserForm1), this will display all of the rows of data that they can select from to edit. Because this data set is large (will...

Hi........I try to automate the SAP theme setting by using Excel VBA. My requirement is “If Selected theme not equal to " Corbu Theme" then change the selected theme to " Corbu” This is the code to load the SAP GUI Options >>>Shell "C:\Program Files...