dialogue

I am stacked with this code and I need someone to fix a few bugs for me. I have observed that when I cancel the dialogue box, then the workbook starts to behave some weird way. For instance, there is an image control on one of my worksheets that I load an image to from a userform – it fails to...

I have the get folder location function listed below. I would like the dialogue box that opens to start into a specific root directory. This will allow the user to start at this location which they select the final destination from the list of folders within the root directory. How to I modify...

MrExcel Community, I have a macro-enabled workbook with several event procedures. When my workbook re-calculates, I'm getting a message dialogue that has a single word, "Calculated". When I search my entire project for the word "Calculated" I can only find that in one comment. I checked for...

I installed the MrExcel HTML Maker addin. I shows as installed in the OPTIONS>ADDINS dialogue, and it the manage addins dialogue it is checked. But how do I access it? I have no Addin's Button in my ribbon or the menu, although in the OPTIONS>CUSTOMIZE ribbon settings, "Addins" is checked. I...

I'm trying to generate word lists that meet certain tests. I would like to use Spellcheck to decide when something is actually a word. I am able to determine if something is a word from the CheckSpelling method return value "TRUE" or "FALSE", but I have not been able to determine how to close...

I'm trying to generate word lists that meet certain tests. I would like to use Spellcheck to decide when something is actually a word. I am able to determine if something is a word from the return value "TRUE" or "FALSE", but I have not been able to determine how to close the spell check...

Hi I have a cell (D45) where if the value exceeds 12, a dialogue box appears when worksheet_deactivate. Works fine, but if the cell is not amended then the message box comes up every subsequent time there is worksheet_deactivate. Can I specify that the box appears a maximum number of...

First off, I believe there is a previously answered post but I can't find it for the life of me. I am looking assign a short cut to a macro that places the cursor in the Name Box so I can enter the desired value. I don't want to use the dialogue box that appears when you press F3. I would like...

I've been googling this everywhere but can't find anything helpful. In my sub I have something like Load.AdSelect AdSelect is a userform that pops up, and all I want it to do is to open AdSelect then close it straight away with no dialogue. Basically, it selects a cell, A3, opens AdSelect...

Morning all, I've pieced the code below to create a Save As dialogue box, with the goal being that the name and file type are already completed for the user. The file name is generated from various other parts of information in the spreadsheet, and in order to eliminate what I thought were...

ActiveWorkbook.SaveAs Filename:=FileSaveAs, Password:="", writerespassword:="", ReadOnlyRecommended:=False, CreateBackup:=False I just observed some issue with this code is am trying to use to save my workbook with the Save As dialogue. When I click cancel it goes on to create a file named...

I use Find & Replace regularly within Excel 2010, pretty much every day. After many years of silently fussing about this, it's time to ask: Is there any way to adjust the size of the font when I type criteria in the "Find What" and "Replace With" fields? Not talking about modifying the text in a...

Hi, I have a formula that uses the INDEX and MATCH functions to locate a call containing a number value. The formula appears to be working, based on the Function Arguments dialogue box however is still displaying a value of 0 in the cell. The formula with the cell is: G3 The formula is...

Hi, All! Whenever I hit press the "Cancel" button on the dialogue box, the worksheet still seems to run the function while searching for nothing. I'm not sure if it's an issue with the working in VBA, or an issue with the dialogue box, but I haven't been able to find a solution. Below is the...

Hi all, I'm currently trying to update a macro that was written in an earlier version of Excel, and I'm getting an error that I'm not sure what to do with. The module that's getting called early in the program starts like this following (excluding Dim statements): For iCount = 0 To 10...