Recent content by crawfme

Thanks to both of you. It's going to take me a little time to digest what you've suggested.

I would like to write a macro that would read in only the first couple lines of a very large text file. Basically I want to read the first few lines to determine if the file meets specific criteria before deciding if the entire file will be opened. I can specify the StartRow for reading data...

Thanks, Strongm, but that doesn't seem to be the problem. Any other ideas?

I'm having an issue with tabbing between fields on a form that I've built in Excel. It works fine on my PC, but when a co-worker opens the spreadsheet and tries to tab between fields on her PC it instead inserts an actual tab character. Here's what happens: If she uses her mouse to select a...

I have an Excel spreadsheet that will be used by 2 users. It has a form that they populate with information required to perform a calculation and they can save their inputs if they choose. Currently there is a sheet in the file where their inputs are saved. The data on this sheet is also used...

Sorry, Skip, this is still over my head. This is my first time creating a form and I'm muddling my way through with the help of Tek-Tips, Google, and a copy of Excel 2003 by Walkenbach (which I believe you had recommended in another post). I think I understand the concept of what you're...

I have designed a UserForm that gathers over 40 pieces of information required to perform an annuity calculation. The data includes dates, dollar amounts, percentages, other numeric data (such as the term in years), and text information (such as name). I have 2 questions: 1. Is there an easy...

Thanks, Skip. I am very intrigued by your suggestion, but I'm not quite sure how to begin. When you suggest creating a format/validation table, where would that exist? Is that on a worksheet? Would you have a simple example of what you're describing that I could build on? As suggested by...

I have designed a UserForm that gathers over 40 pieces of information required to perform an annuity calculation. The data includes dates, dollar amounts, percentages, other numeric data (such as the term in years), and text information (such as name). I have 2 questions: 1. Is there an easy...

Gerry, thank you for taking the time to write such a detailed reply. I'm sorry if I haven't been clear enough about what I'm trying to do. In your simplified version where the userform has 3 textboxes, the value in textbox1 (which I've called txtCaseID) would be the caseID. The only reason I...

Hi fumei. I'd cut and pasted Petrosky's suggestion and modified it to do what I wanted - I must have missed the "dim i as integer" declaration. Sloppy, I know. I'm new to programming Excel forms and I'm finding my way by searching the internet and asking questions in forums such as this. It...

Thanks for the input. I have many objects on the form, all of which I have named with meaningful names and prefixes that indicate the type of control e.g. lblName and txtName. The problem was that I wanted to saved the inputs to a table on a worksheet so that I could re-populate the form with...

I have created a userform and would like to have a list of the objects that I have placed on the form (labels, textboxes, etc.). I have used 3-character prefixes to differentiate between the different types of objects, but it would be useful to see an alphabetic list of them all. Basically...

Currently I have the history file open and I have a macro that I run from the calculator that reads the data from the calculator and cuts and pastes the results as values into the history file. What I'm hoping I'll be able to do is not have to open the history file at all. If the user wanted...

Thanks Skip. I've been playing with this and it's going to work. The FAQ that you pointed me to says that you can both retrieve AND update data using query, but I can't seem to figure out the update part. I have a spreadsheet that is a calculator. What I would like is to have a separate...