Recent content by Zebadiah

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

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)

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.

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

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?

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.

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

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

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?

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.

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?

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

Already tried that. It seems to ignore it in favor of scientific notation.

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

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