visualbasic

I have 2 sheets, one is a library of sorts (Sheet1) that has an Id column and then corresponding filter values for columns on Sheet2. That Id column from Sheet1 is NOT on Sheet2. Conceptually, what I want to be able to do is click on the Id column on Sheet1, then filter Sheet2 based on the...

Hello, I'm trying to write script wherein I need to find the sumproduct of numbers in column A and column D. The issue is that this data length varies from sheet to sheet hence I need to write a script that finds the number of rows that has a number present in it and then compute the sumproduct...

hi guys! how do i write this in VB =MID(A1,SEARCH(" ",A1,1)+1,SEARCH(" ",A1,SEARCH(" ",A1,1)+1)-SEARCH(" ",A1,1)) i want to have this formula inside my already created function SKU in VB, I really dont know any VB. Function SKU(myEntry As String) As String SKU = Left(myEntry, 3) &...

Hi everyone, I'm a newbie with VB and excel whose stuck at a task since quite a while. I promise I went through the threads already and found a similar one here for blank values. Tried modifying the code but it didn't work for me for multiple scenarios, the only one I could spot was for...

Hello, I have searched far and wide so if there is already a thread answering this please let me know. I am running a macro in excel that communicates with Reflections. I need it to set my cursor position at 3,25. The issue I am having is with: .SetMousePos 3, 25 .TerminalMouse...

Hello, I'm currently building a disciplinary report log for work. The design of the log is simple; I have a table in Sheet 1 with rows corresponding to employee names. Each column represents a general category of possible infractions (e.g. safety; cell phone usage; failure to comply with...

I am very new to Visual Basics and MapPoint, but am faced with the following task: On a row in excel, I have two addresses. I want to call a function (macro?) in excel that will plot these points in MapPoint and return the distance between the two into a column in excel. I realize this is a...

Would like to automatically alphabetize named ranges on one of my sheets.. I have about 20 columns all defined name ranges, The data it pulls is text, specifically its peoples names. I want these columns to alphabetize automatically. Vb code I would assume. HALP! Need this for my valet...