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 Rhinorhino 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. Zebadiah

    Excel 97 Data Validation Pulldowns Error

    Checked for all Never use combo box controls, I prefer macros with buttons to activate different choices since most of what we are doing has discrete scenarios Some of them started on merged cells, and unmerging doesnt get rid of the ghost, in fact the ghost stays where the second cell was but...
  2. Zebadiah

    Is there a limit on Excel97?

    Also, in re: size of files, my experienced limit is around 120mb before excel has problems with the files, at 140 mb, I've been able to create this size but can never reopen the file. (Dangers of running macros that post lots and lots of data into what starts as empty cells)
  3. Zebadiah

    Excel 2000 Macro (Stop the flickers well running)

    This also will make your macros run faster, updating the screen appears to take a lot of clock cycles, the macros that I ran before this would take several minutes to run before I turned off the updating.
  4. 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...
  5. 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?
  6. Zebadiah

    Functions and Maximum # of arguments

    OK an addition, the maximum number of variables that excel can handle as far as I can tell is 29. After that I get a #Value error.
  7. 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...
  8. 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...
  9. Zebadiah

    Word and Printing

    I'm trying to do the same but in Excel, and it doesn't recognize the Application object. Any idea what I'm not initializing?
  10. Zebadiah

    excel vba, rounding a textbox value

    Feeding from a calculation that isn't in scientific format. Wound up getting it to finally display right by making the text box twice as large as I'd like.
  11. 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?
  12. Zebadiah

    excel vba, rounding a textbox value

    Nope, the cell value displays correctly. But in the textbox on my form, its in scientific notation
  13. Zebadiah

    excel vba, rounding a textbox value

    Already tried that. It seems to ignore it in favor of scientific notation.
  14. 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
  15. Zebadiah

    Changing focus on Tab press, not earlier

    I figured I had better expand more. One of the ones i'm trying to do is a simple Fraction conversion So textbox1 is input Textbox2 is output What I've been trying is to put in the Private Sub Input_Change() Output.Value = (1/INput.Value - 32) * 5/9 End Sub But if You start to enter a...
  16. 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...
  17. 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...
  18. Zebadiah

    Refreshing screen at run-time

    Have you tried: Application.ScreenUpdating = True ? Might work, might not. For me, it works most of the time.
  19. Zebadiah

    Security in VBA

    That's what I thought. Had someone try to convince me that its ultra secure.
  20. 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...

Part and Inventory Search

Back
Top