Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Firery

    Excel-VBA-ComboBox List display problem

    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...
  2. Firery

    Search for file, using properties 'Title'

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

    Search for file, using properties 'Title'

    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.
  4. Firery

    VBA Password query after App has ended.

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

    VBA Password query after App has ended.

    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
  6. Firery

    Navigating in Userform

    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
  7. Firery

    VBA Password query after App has ended.

    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...
  8. Firery

    VBA Project Protection

    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...
  9. Firery

    Reference Library

    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...
  10. Firery

    Reference Library

    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...
  11. Firery

    Auto Close & Saving Problems

    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...
  12. Firery

    Create, Copy & Name a file using VB

    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...
  13. Firery

    Create, Copy & Name a file using VB

    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...
  14. Firery

    How to? Display xls cell value in a userform or message box

    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.
  15. Firery

    How to? Display xls cell value in a userform or message box

    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...
  16. Firery

    Help!, macro error appears on one computer but not on another,

    Thank you all for your help, 'Paul Beddows' got it right. this is the script from my XP macro Range(&quot;A1:D30&quot;).Select Selection.Sort Key1:=Range(&quot;B1&quot;), Order1:=xlAscending, Key2:=Range(&quot;D1&quot;) _ , Order2:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, _...
  17. Firery

    If file name = 'abc', then run macro1

    Create an Auto_Open macro for file ABC.xls in VB, with macro3 within, when the file is opened the macro will execute automatically.
  18. Firery

    Help!, macro error appears on one computer but not on another,

    I am running Office XP Pro at home. I created an excel workbook with macros. some macros sort data within a range. My home computer runs all macros correctly with no errors. I take the same program to work (Office 2000) and get syntax error at the point of sorting the data in the range selected...

Part and Inventory Search

Back
Top