macros and vba

Hello, I am still in the process of learning macros, and I was tasked with the following scenario, please help steer me in the right direction! I have an excel workbook that is populated with lots of pricing information. Column A is the product_ID and I want column AP to be the lowest...

Hello, I'm new to VBA and trying to make a custom Dashboard for a manager. Below lies my attempt at creating a data refresh and save macro that will be tied to a button on the "Dashboard" sheet. My main question is: Am I actually calling the RefreshData() sub twice in WriteData(), thereby...

Hello! I'm new to VBA, this is honestly my first time playing around in it, and I need some assistance. I have a group of cells on my excel sheet that I want to have copied and pasted into the email body, but everything I try comes up with nothing. :( Could anyone help? I also really need my...

Hello, I am looking for any assistance in relation to Excel Macros and VBA I am currently using the following on my Excel Workbooks (which were kindly provided by people on MrExcel) Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+z ' Dim ws As Worksheet For Each ws In Sheets...

Hi, I currently run a macro via a button, However when I copy the worksheet into a new workbook (which I must do regularly as part of our process with new jobs) , the button remains assigned to the macro in the original workbook and does not change to the macro copied with the new workbook...

I have a written a script in VBA. while checking a CheckBox, it should check if respective cells(D26,D27,D28) have numerical value or not. The below code is working if I am writing values under/or 10000. If I am giving some larger values, its not working. Please help me how to achieve this.

This is My macro: I want to count each cell depending on the colour for a particular range. Below is the example of the macro used: The bracket in red is the range I am searching for the colour specified in cell B1. This "CountByResult" only works when I click on the cell that contains the...

Hello, i have created an excel file where there is a button and when the user presses it, it prompts a window for the user to select a CSV file to be edited. After the file is selected i make some changes and save it to a new csv file that works fine, but i struggle to add double quotes (") to...

I have a macro that works correctly when I run it from developer mode, but when I try to run the macro by clicking on a shape that has the macro assigned to it, it does not work. Can someone please tell me how can I fix this error, since I need to be able to run my macro by clickin on the shape...

Hi everyone, I know Microsoft recently changed their rules about using macros on files on sharepoint, has anyone managed to get around it? I've tried adding it as a trusted site but it still doesn't allow it. Thanks in advance for any advice!

Hi Excel brains trust, My company have created a Report generator using a spreadsheet + VBA/macros. To use it, our employees fill in a row, select a template from a dropdown, enter the reference pertaining to it, and then click a "Create Document" button. The code then reads which template is...

Hi! I'm trying to do this in Excel using Macros. I can't find any code to do this: The user should be able to push a button on the Large Dataset tab that brings up a user input box. (Hint: Learn how to do this by watching the tutorial video on creating a button) The macro should prompt the user...

hi I need to search sender e-mail address excluding microsoft and no-reply@notify.aol.com for a date. This code work for microsoft only. Filter = "@SQL= (NOT urn:schemas:httpmail:fromemail like '%microsoft%'" & _ " And urn:schemas:httpmail:datereceived = " & daterec& "))" But when...

Hi there, I am looking for assistance in automating a task in my job. I am a novice when It comes to using VBA/macros and so far I have been unable to get answers to my problem through browsing the website. My objective is the following: I have a folder directory in which daily excel...

Hello everyone. I am using a macro to consolidate two files and have the information referenced between two sheets, but when the macro is supposed to paste a formula {=IFERROR(VLOOKUP(B6,GTN!A:C,2,FALSE),""}, what I end up getting is a different one {=IFERROR(VLOOKUP('B6',GTN!A:M:M,2,FALSE),"")}...

Hi all Mentors, Deeply appreciated any help. I have created one excel for stock entry, there are four sheets, in that; first is Home sheet where in Cell B5 there I want to one moving text from right to left. I was able to achieve that task, but when I am trying to navigate with other sheets...

Hello I'm trying to figure out a way to open the workbooks using the array values stored. The only bug I encounter is at "Workbooks.Open(StoreList(0))" where I encounter "run-time error 0 subscript out of range" but the address is correct so I don't know why it can't find it? Sub uniquestores()...

Üzerinde çalıştığım site iWorkBetter altyapısı kullanılan yapılmış. dolayısıyla internet explorer vba kullanmakta sorunlar yaşıyorum.. bilgisayarda selenium varken aşağıdaki kod ile seçim yapabiliyordum ancak şuan selenium kullanmam mümkün değil. dolayısıyla sadece excel vba ve ie tarayıcı...

I'm creating a database of a library, I created a macro to check if the expiry date of the request that the user made has already passed, if this has happened the cell value should be "Expired Term" otherwise it should be "Pending" , but when the program executes the macro it always shows the...

I have a macro to check if the user has entered the "Username" and the "Password" correctly depending on the data present in another excel file, it happens that I enter the data correctly and the program detects that the password or user is wrong Private Sub bt_seguinte_Click() 'Oculta as...