Search results for query: *

Hello all, I am using the built in Save As dialog box to get the name for a text file I am going to write out. However, I want to check to see if the filename already exists in the directory the user wants to save the file to. If the file already exists then I would like a message box to...

I know what I want to say in English but can't come up with the right code that will do what I want. Here's kind of what I want the code to do using my English/VBA sub-dialect. Sorry for the non-technicalness of the code: On error goto handler Handler: if the worksheet is protected then...

So here's the deal: I have 10-15 comboboxes on one sheet where you can select various items from them. The selections from the comboboxes are then placed in cells in other worksheets of the same workbook. There is an option to select nothing from the combobox (ie blank line). If the blank...

I'm having trouble launching a help file (with the ever creative title of "help")I created from the menu I created for Help. Private Sub mnuHelp_Click() App.HelpFile = App.Path & "\help.hlp" End Sub Am I missing something here or does anyone have an idea why this...

I would like all my MDI child forms to come up in the absolute center of my MDI parent form. It seemed logical to me to change the StartUpPosition property of the MDI child form to 1 - CenterOwner but I get an "Invalid Property Value" error with that. Any help would be greatly...

I've created a custom menu bar and would like to add the print option from the file menu to that bar. I've written the code to create the new menu bar but just need help with the code to assign the print option to the NewItem that i've created call "&Print". Thanks in advance.

Does anyone know how to hide the menu bar (ie File, Edit, View, etc.) in Microsoft Excel? Thanks in advance.