dialog

I'm trying to save a sheet in the spreadsheet as a PDF, when it's ran I get the grant permission dialog box as well as the dialog to set the location and specify the file name. The file names are pre-set based on the FN value passed. Example: FN = test.pdf I want to completely bypass the both...

Does anyone by any chance have a macro that can do the following? 1.) Call up a dialog box with a find (search) field 2.) User types in desired search for BOLD text items only 3.) Searches for and finds the first BOLD text item instance 4.) Closes dialog box automatically 5.) Navigates cursor...

Hi Everyone, The other day excel started adding horizontal lines to the border across the entire row of any cell that i input data. The top line is a normal border, the bottom line is a thicker border. I thought it might have something to do with tracking changes, but I have tried to tinker...

Hello experts. I really need your expert help. I'm trying to automate the work with the IE 11 browser. I wrote a macro, but there was a problem. I can not automate the work with the IE browser dialog box. During the work of the macro, the site opens a new IE browser window with an already open...

I'm writing a macro that produces a table from external data, and I want the user to be able to format the report using a table style that they can modify. Is there a way that I can "call" the Modify Table Quick Style dialog from the macro and allow them to amend it? I know that I could create...

A quick pop up says "Establishing connection to url..." Then the Navigator window opens up with 2 tables to import. I choose Table 0. After I click Load..., I get this dialog box: I tried to Google that message but I didn't see anything reliable. Perhaps you have an inkling what is going on?

I have a workbook for creating quotations of our products. In my main user form, I created a button to use Application.FileDialog(msoFileDialogFilePicker) to open another excel sheet to import pricing updates. This subroutine was giving me trouble, so I decided to scrap it. I deleted the...

I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...

I have a routine that creates a new copy of a worksheet and then the user inputs data through drop down boxes. In zip code, I have the cell with data validation linked to a named list of zip codes. However, one can enter anything in the dialog box and it will input it into the zip code cell...

Does anyone know of any Excel Add-Ins, or the like, that supply common user input dialogs? I used to program in Avenue for ArcView (ESRI) and, though the language itself was cumbersome, it had some really cool standard input dialogs that could be called. Some examples of those were combobox...

Dear all, I've been using VBA's for a while now. But there is one simple thing I am not able to solve and google doesn't help. I have have financial reports in several sheets with all the same layout. From all sheets I want to print only the range A1:N68 The following code helps me to print...

hi guys I've been lurking the forum for a while now and has always found good answers. However, I'm having trouble finding a way to simulate the file open dialog using VBA. I'd like to users to click a link to a directory and it opens in the File Open view as if the users just clicked File/Open...

Hello, I have a question. I want to replace things with a regular CTRL+H dialog. Lets say my formulas are in this format: =RIGHT(LEFT($B2, 4), 3) Now, this formula has different targets spread around sheet. I want to remove everything around the $B2 and keep it since it differs for every...

Hi there. I am developing a macro-enabled workbook for distribution to a variety of co-workers. I'm planning on distributing a macro-enabled template (XLTM). I'm struggling with code to do the following: Upon opening the XLTM file (by simply double-clicking), I'd like the user to be forced...

Hello, I would like to allow a user to select a printer from the Printer dialog. Then, I will save their selection so I may use it in future steps to print to that printer. Note, I do not want the user to print to that printer after it is selected. I need to save the value of selected printer...

When using the file picker or open dialog via the FileDialog property you can select multiple files to open, is it possible to restrict users to only selecting one file?