Search results for query: *

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

I am using Excel 2003 and have followed the steps on the Microsoft website at http://office.microsoft.com/en-us/excel/HP052022151033.aspx to populate a drop-down box with a list of values from another workbook, but I get an error message that says "You may not use references to other worksheets...

This is more of an annoyance than a problem, but I'd appreciate it if anyone has a fix. The other day I selected File Open from the menu in Excel and hit the maximize button so that I now see a full screen. Now I can't get it to shrink back down - there is no "-" symbol in the top right hand...

Thanks Michael, this is a network printer so I'll call our Help Desk to see if they can do something with the driver.

I am having trouble printing an Excel report that has multiple pages with the same layout on each page. The report is numeric data with borders around certain cells. When I have the graphics mode set as vector, the right hand borders print fine on page 1, but are shifted slightly left on all...

I want to be able to build an "average" formula where I am calculating the value of the beginning and ending row to use in the formula. For example, if the formula I want is =AVERAGE(A2:A7) I want to be able to build the formula and calculate the values 2 and 7. If there was a formula in cell...