vba variables

  1. W

    variable variable based on other variables?!

    Hi All, If I wanted to state a variables value based on another variable, how could I do that? The two variables I current have in the script are Dim Red as Long Dim Green as Long Dim Amber as Long Green = Sheets("HURDLES").Range("C5").Value Red = Sheets("HURDLES").Range("E5").Value What I...
  2. H

    VBA how to clean Variables

    Hi I am writing VBA code to control powertpoint from Excel my code is Private ppt_2 As PowerPoint.Presentation my question is: How to clean\empty PPt_2 variable, set ppt_2 = nothing, closes power-point file and I don't want to close the file. Is there any other way to clean variable...
  3. A

    VBA, Defining the current workbook as a variable

    Hi All, I am writing a macro that starts in one workbook (who's file name will change weekly) and will also access a reference sheet on the network. The goal is to copy the reference sheet into the first workbook. In order to do this I'm using the following code, but I am not getting past...
  4. H

    Help with form variable user option

    Hello I am creating a time sheet workbook. I've figured out how to have the punches go to a table and a general journal, based on Start, go to break, back from break, go to lunch and back from lunch and go home. What I am wanting to do ... is have a seperate work sheet for each employee...
  5. B

    VBA global variable contents clear?

    I've inherited a large Excel application that cashes data retreived from an Access database in VBA global variable arrays when the application starts up. It then builds worksheets from scratch by adding a default sheet to the workbook and inserting all formating and data. All calculations are...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top