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!

  • Congratulations wOOdy-Soft 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: *

  • Users: Zebadiah
  • Content: Threads
  • Order by date
  1. Zebadiah

    Excel 97 Data Validation Pulldowns Error

    I've got 2 issues 1. In a recent spreadsheet that we use as a template, we've had a corruption of some of the cells where we use data validation with a dropdown list. What's happened is that a "ghost" pulldown button has appeared in some of the cells that use data validation and...
  2. Zebadiah

    Filenames and changing from 1 wrbk to another

    I'm writing a macro that will let me export data from one file into a template file, but the source file name will change each time. How do I pass the workbook filename to a variable so that I can call the variable in workbook.select?
  3. Zebadiah

    Functions and Maximum # of arguments

    I've written a function that has 32 arguments (variables) and when insert the function into the excel cell for calculation, it gives me an undefined error and always highlights a cell reference in the function. Is there a maximum # of arguments that a function in VBA can handle? Function...
  4. Zebadiah

    Installing ACadd LT 2002 on network

    We've purchased a single license and wanted to be able to use license management such as was available in earlier versions of Acad. We've got a total of 5 users but rarely would we all need to access it. Is there a way to install ACad 2002 LT so that it will only let 1 user access it on the...
  5. Zebadiah

    Xbox form control

    I'd like to reassign the button on the upper right corner of the window (the X) from just closing the form, to closing the entire excel file. Any ideas?
  6. Zebadiah

    excel vba, rounding a textbox value

    My problem is that the calculated value is too small, so in the text box it displays as 5.209933-E02 When what I want is 0.0521 I've tried Round as a function, but vba doesn't support it, and my IT just reinstalled everything on my machine, EXCEPT the VBA help files. thanks in advance
  7. Zebadiah

    Changing focus on Tab press, not earlier

    I'm trying to have the user enter a value in a textbox then have the other textbox values calculate based on the new value entered in box 1. Problem is that the value that I have to enter is a decimal value, and when I press 0 i get a division by 0 in the formulas, and if i just use...
  8. Zebadiah

    Textboxcontrol and math.

    On my spreadsheet, I have 2 cells for data entry, that I have linked to textbox controls on my Userform. There are 8 other cells that use those 2 cells for calculations, based on formulas entered in those 8 other cells. On the Userform, I have eight textboxs to display the values in those 8...
  9. Zebadiah

    Security in VBA

    How secure is the password protection for modules in VBA in excel? I'm primarily concerned with the add-ins falling into a competitors hands and gaining access through some of the companies that offer password recovery. I know that the passwords for a word and excel file are recoverable, but...
  10. Zebadiah

    Office XP/2000 Developer and Excel

    Hail, We currently have a large Excel spreadsheet file that I'd like to be able to release as a runtime similar to the Access distributable runtime. Has anyone had any experience with the new Office XP dev package to know if you can easily turn an excel sheet with formulas and code into a...

Part and Inventory Search

Back
Top