Recent content by Firery

Greeting, Excel 2003, Workbook with a form. The form has a ComboBox which is populated during the UserForm_Initialize. The Combobox 'Style' is set to 2 - DropDownList. The last line in the initialize is to DropDown the list in the combobox for the user to view when the form appears...

Thankyou REMOU Works perfectly I hope my knowledge attains a level where I can help others too.

Thanks for even looking, I'm trying to write a code in VBA (Excel) to search for a file with a specific value in it's builtindocumentproperties "Title". With Filesearch, I can search using 'TextOrProperties', but I only want to find a file with a specific property (title). Hope someone can help.

The problem has appeared on another PC running NT, without GOOGLE search. The strange thing is that it is not consistant.

Thanks rmikesmith Your thread mainly describe my problem being caused by having GOOGLE Search installed. I don't have it installed, so it must be something else. I have had a good look at my Before_Close but can't identify anything there. So I'm still looking

With a TextBox control, this will stop the user exiting the control if the wrong value is entered. It should give you the idea. Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean) If TextBox1.Value < 50 Then Cancel = True Else 'Any other Code you like End If End Sub

I have created an Excel spread sheet with numerous sheets and numerous VBA forms and code. I keep the VBA Project locked from viewing with a password. I have been making slight improvements as you do, and my program is working fine. Recently, on the odd occasion, after I have closed my Excel...

I have created an Excel spreadsheet with VB locked from viewing. A friend has shown me a program called "Advanced VBA Password Recovery" which was able to change the password for the VB Project without even opening the file, thus allowing someone to open the file and then view my VB code with...

Thank to All for you input, but I got around my problem very simply, In my Sub - "BeforeClose(Cancel As Boolean)" I placed; If Range("a50") = False Then Cancel = True End If (A50 is in an out of the way section of my program) My EXIT button sets A50 to True and then Quits the...

Hi, I have a code in my "Before_Close" Sub, which stops the user closing my Excel file using the X in the top right corner. To exit I have an exit button which sets range "A50" to TRUE,then saves and quits. This bypasses the "If CloseMode". My Workbook_Open sets "A50" to FALSE If...

I have a few Excel Spread sheets projects with their own Auto_Close modules. The modules make the toolbars visible and a few other things as well as 'ActiveWorkbook.Save' to ensure any changes are saved. Problem - If I have more than one project open, and close one, the Auto_Close for the other...

Thanks all for your support. johnwm made it the simplest. I have recorded a few macro's to see how the code reads. Coping the data wasn't the problem, creating a file with the date as the name was the hard one. Now how do I name a file using the value of a cell, eg. cell a1="2 Mar 04" (fixed...

Using MS Office XPPro I have a excel WorkBook with numerous sheets, One sheet "Summary" displays a summary of information from the other sheets by way of formula's. 1. I wish to save the worksheet "Summary" as a new xls file with only the values and formats displayed, no links to the original...

Thanks ca8msm Actually, all I needed was Private Sub CommandButton1_Click() ' return value of cell A1 MsgBox Range(&quot;A1&quot;) End Sub Took me a little while to figure it out.

I wish to display a message box or userform, which will display the value of certain cells from a workbook. eg. Sheet 1, Range a1 = &quot;12th Dec 2003&quot; I want the userform to display &quot;12th Dec 2003&quot; I know that this is probably a menial task for most of you but I would...