command button creation

  1. A

    VBA command to open PDF

    Hi All, my first post here :) I am trying to create an interface to select and open PDF reports from Excel. Currently I have got 4 drop down boxes where users can select which report they would like to see. Currently the options are drop down box 1 : Europe, America and Pacific drop down...
  2. iouu2

    **HELP NEEDED*** VBA / Macro For Print with Command Button

    Took basics in Undergrad but don't even remember how to create a command button any more :confused:. What I need is a command button that can make it easy to print various tabs within the excel workbook and make them print ready (meaning click of a button and you can select which tabs you...
  3. D

    VBA Code for Access Command Button to Create a New File Folder

    I have an Access Data base with a given form that creates a new recorded with the Prime Key called (MDR#). I want to add a command button to the bottom of the form so when they click on it, it will create a folder in a given location (On the network) with the folder labeled with the "MDR# (MDR#...
  4. B

    Locking a Command Button to a cell:VBA

    I am currently using the code below to create my command button.The problem im having is that columns are adjusted sometimes so the button gets in the way. ActiveSheet.Buttons.Add(1200.15384615385, 26.5846153846154, 179.446153846154, 23.8153846153846).Select Is there away in the code to lock...
  5. C

    Colin

    Control button coping when using VBA's column copy: I have a sheet with regular sets of columns, and I need to be able to select my column groups and paste them at the end of my data, or within the middle of existing groups. I have the column copy/paste details in VBA sorted out, but now...

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