dialog box

  1. M

    Help setting fixed values in an amazing macro that splits columns using dialog box feedback!

    I have an amazing macro that uses dialog boxes and allows you to select a column of data, and break it up into multiple columns based on a number of rows you select. Then output those columns starting in a cell of your choosing. Starts as: (I choose 2 rows per column) 1 2 3 4 5 Becomes: 1...
  2. B

    Expand default size of Define Name dialog box

    I raise the Define Name dialog box frequently; it displays up to 10 named ranges without scrolling. Most of my applications have more than 10 named ranges, often a lot more, thus requiring scrolling to see most of them. Is there a way to change the default height so that it always comes up...
  3. D

    VBA to overwrite an existing excel file (SaveAs) when you only know the File Path?

    Hi Folks, I have a VBA model (*.xltx in draft stage) in which I import a specific excel file (containing multiple ws) from a specific file path. I am modifying some of the data. Once modified, I want to SaveAs to overwrite the file I originally imported. The file I'm importing will be called...
  4. C

    Macro: Open native dialog box in center of Excel

    I am trying to make an Excel macro that opens the worksheet "Activate" dialog box (normally opened by right clicking on the navigation arrows in the bottom left of the workbook) in the center of the Excel workbook (must work for a multi-monitor set up). The below code (from...
  5. P

    Save As dialog box looks weird

    Hey Guys, I'm losing my mind a bit here trying to get my Save As dialog box to look normal again. I've done a fair bit of googling and can't find a fix (or anyone that's ever had this problem!). The below screenshots show what my Save As box looks like now, vs how it should look. Does anyone...
  6. I

    Dialog box to select a file to extract from (without open it)

    Dear all, I am trying to write my first code, it will extract (copy) content from different sheets and cells from a file (source) and paste it into the next empty row of another existing file (the database) The source has always the same exact structure, only different data, the previous idea...
  7. F

    Show Pivot Table Filter Box using VBA

    Hi Everyone, This is a simple question and hopefully someone has a simple answer! :) Does anyone know how to Show the Pivot Field Filter & Sort dialog box (see image below) using VBA? I have a sheet which requires me to hide the pivot table header row so the user is unable to click the...
  8. JoCook

    Rename tabs from dailog box with dates

    I am trying to create a macro that will rename all tabs that have been named with a date mm-dd-yyyy. I would like a dialog box to pop up and ask for a starting date and then have the macro find the tab names with the lowest date and then rename them to the next years dates For example current...
  9. F

    how to put dialog box to open a file ?

    I want a dialog box to prompt user to open MISSINGUSERNAMEDEPT file . any ideas? Thanks in advance Here are my codes below: Private Sub Simpat4_Missing_UserName_Dept() ' ' Update User Name and Dept from Missing User name & dept xlsx file ' Step 29 ' Dim MaxRowNum, RowNum As Long With...
  10. E

    Open a new file using a dialog box pop up without specifying the path of the file

    Hello Everyone, I need help in writing a code which does the following: 1. Open /pop up a dialog box which asks the user to select a file from the computer 2. Copy paste the data from a worksheet in another workbook (say workbook A) to this newly opened workbook I am not the only person who...
  11. C

    Dialog Box, Form, or Macro that Adds Rows of Data to the End of an Excel Table

    I have a spreadsheet in which I need to create a dialog box, form, or field-entry box for simple end-user data entry that automatically adds entries to the bottom of a table. My end-users are very inexperienced using excel and I want to design something for them that makes for simple data entry...
  12. H

    VBA User Form help - How to save current worksheet as a csv file?

    Hi, I'm working on a workbook (contains two sheets) that users can log certain data with a user form I created. I'm new to vba but doing pretty well, however one of the areas I'm struggling with is on the form creating a button, and when the user clicks it it saves the active work sheet to a...
  13. S

    Worksheet not active after dialog box closes

    I'm using VBA to display a dialogue box (user form). When I close the dialogue box, the Excel worksheet is not active - the title bar is dimmed. I need to click somewhere on the worksheet to make it active. I've tried lots of VBA commands to achieve this without success. What am I missing?
  14. P

    How do macros handle/interface with popup boxes/message boxes

    I have a macro that is supposed to copy the contents of a SharePoint folder to my C:drive, Sub CopyWorkbooks() 'Note: If ToPath folder ("C:\Aggregation\") already exist it will overwrite existing files in this folder 'if ToPath does not exist, it will be made for you. Dim FSO As Object...
  15. D

    Why is the filename appearing in the macro dialogue box?

    Does anyone know why the filenames for most of my macros are appearing in the macro dialog box (in Excel 2010) and, more importantly, how to get rid of them? Example: PERSONAL.XLSB!ClearFill Thanks! Doug
  16. H

    VBA Code to Access "File Download" dialog box and procced with Save option

    Hi All, Can anyone help me to complete my code (Excel VBA) to automatically process a File Download dialog from Internet Explorer. I want to click "Save" which will produce the "Save As" dialog. Then file name should access from A1 cell and should get save in C:\Temp\ and click "Save" again...
  17. B

    Dialog Box Launcher greyed out...

    I want to group columns in excel with the main column to the left, not right (as is the default). According to other posts, this can be done through the Outline Dialog Box Launcher... but mine is greyed out Dialog Box Launchers seem to work just fine everywhere else they appear in the standard...
  18. J

    VBA, import file via dialog box to workbook

    Hi all, Forgive me if this has already been answered, ive been looking for a while now and not found an answer that works for me. Im trying to use a command box that will open a file (allfiles is what im looking for) and import it from a network drive into a worksheet in the same excel file to...
  19. D

    How to open excel file with choosing a filter on opening?

    I have an excel table with sales data for many presellers. I have to make and updating table for each of presellers. I want to make one file with data for all presellers and to create a shortcuts to preseller folders and when some preseller opens file from his location I want excel to aply...
  20. S

    Open an external file from excel and store the file path in a cell

    This may sound odd, but I was looking for ways to create a macro that would open a a dialog box that would prompt the user for a file that would then store that filepath to a cell, allowing the user to click on the cell to open it again. The excell sheet would serve as a checklist for many...

Some videos you may like

This Week's Hot Topics

Top