dialog

The code below shows the fill colour dialog. Is there a way to automatically go to the Custom tab as shown. Sub colour_fill() Application.Dialogs(xlDialogPatterns).Show End Sub

Getting a "Run-time error '91'" when running this code. Thoughts? Sub OpenNewCSV() 'Dim fDialog As FileDialog, Result As Integer 'Set fDialog = Application.FileDialog(msoFileDialogFilePicker) Dim fDialog As FileDialog, Result As Integer Set fDialog =...

Hi all, Hi Jaafar ;) I am working on a tool manipulating the VBProject of other Excel files, which can have their VBProject locked with 2 different passwords. But I have no way to know which one it will be in advanced, so I must attempt them one after the other. I managed to write some code...

Hi I'd like to load Excel BuiltIn Dialog Boxes by using the following line of code or similar and where the strDialogBox variable contains the name of the Dialog Box to load. strDialogBox="xlDialogFontProperties" Application.Dialogs(strDialogBox).Show How would I do this? I'd like to open...

I have two workbooks that I open every day. Workbook #2 relies on cells in workbook #1 . Occasionally, I need to save Workbook #1 with a different name, but when I "save as", it changes the relationship source for cell references in workbook #2 . What I need to be able to do is run a macro...

I have just updated to Office 16. I am trying to add a cell from worksheet and a cell from another worksheet. I use the formula; =A1(first worksheet) + a1(second worksheet) and enter. I am getting a REF error and a dialog box that look slike it needs to know a file location? Thanks, Mark

Hi all, Excel sometimes hangs on this dialog box This happens at the end of a loop and in this instance, it successfully completed 55 iterations of the loop before it got stuck here. Any ideas how to prevent this without disabling the save? I'm ok with it skipping one, two or even three...

Hello, Has anyone encounter a Run Time Error 438 - Object doesn't support this property or method when running VB code for File Dialog - Filters.Add in Excel for Office 365? Typical codes: Set fd = Application.FileDialog(msoFileDialogFolderPicker) With fd .ButtonName = "Select"...

Hello, I am building a user form which will be used for data input in some sheets in the workbook. In order to export the current progress without closing the form, using save as dialog, I want to export the workbook (copy sheets to a new workbook) using vba by clicking a button. But all I can...

Hi All, If I'm using a code to produce a dialog box to save the file, I've noticed that the dialog box does not pop in front of the excel document but sometimes behind it. How do I express in code for the dialog box to pop up in front of the working excel document? Please let me know, if...

Hello I am having challenges with sort order within a powerpivot. I am attempting to follow instructions on cascading totals, and in those instructions, is the dialog box shown below. I have researched and looked for this option in both the underlying table and corresponding data model table...

Hello I am having challenges with sort order within a powerpivot. I am attempting to follow instructions on cascading totals, and in those instructions, is the dialog box shown below. I have researched and looked for this option in both the underlying table and corresponding table within...

Hello, I need assistance with a little bit of VBA code. The code needs to: Identify all the blank cells in Column D, It is the last column. Display a pop up dialog / Userform A response is entered by the user in the dialog. Whatever is entered into that dialog will then fill ALL of the blank...

Hi, I will preface this by saying that I'm new to VBA. I'd like to write some code for a command button that will complete a series of actions and then create a series of dialog boxes with fields that the user can then type in, and then when you close the final dialog box, all of those things...

Hello, I would like a little help with the following please. I have found a "file open dialog" script on the internet and would like to use it with the macro that I already have so far. I have a spreadsheet that I want to press "select file 1" and import the .SPF file into tab data_ZOS_1 and...

The following line of code opens the Excel Add-ins dialog window (also accessed via ALT-L H): Application.CommandBars(1).FindControl(ID:=943, Recursive:=True).Execute Can you please advise a similar line of code which would instead open the COM Add-ins dialog window (also accessed via...

Hi all; I will be grateful if you provide me with a VBA code for the following: A dialog will be opened and ask the user to choose the cells (could be separate cells not a regular range)(all cells are numeric values) Another dialog will pop up with the cells chosen for the user to confirm. A...

Hi all Ive got a bit of a strange one. I have a macro which opens various files, and saves them. Occasionally on opening or saving, the macro seems to pause where the opening/downloading or saving dialog box appears (the one which shows progress on downloading/saving). The only way to get it to...

I go thru this every time I reinstall O365. I get a "Can’t find Project or library dialog box" on this first line of code colnum = Round((Date - DateValue("12/20/2017")) / 7, 0) with 'Date' highlighted in blue. In the Tools References dialog box Microsoft Windows Common Controls-2...

I have two membership type databases (they are in no way connected, I mention both for illustrative purposes) Both use a form to input data, the control source for each form is a query and each query updates respective tables. In both databases, there is a Command Button the purpose of which...