| Thread | Last Post | Replies |
|
| Cant find dialogsheet | 24 Feb 2005 12:27 GMT | 3 |
I have macro created by someone else I have there a user form with some buttons and I wish to edit it in case to add new buttons. The problem is that I cant find it in user form tree. All what I have found is line in code:
|
| Advice please | 24 Feb 2005 12:18 GMT | 2 |
Just wonder if i could get a page to automatically put a page in a workbook and create a command button to link to it. let say i save a page called hotel
|
| Excel "drops" text if cell content is bigger than what is displayed ... | 24 Feb 2005 11:35 GMT | 2 |
I noticed that occasionally data gets lost when I copy a cell from one Excel spreadsheet to another. The textcontent of the cell is larger than what is displayed and it seems like everything that is not visible gets truncated during the copy/paste operation. Is this a problem with
|
| Compare cell values | 24 Feb 2005 10:53 GMT | 5 |
I have a number of cells, each containing a different string value. Is there a way for me to determine whether a string from position A1 in my sheet, exists anywhere else in that same column on my sheet. ie does text from Cell A1 match any text between Cell A2 and Cell A100?
|
| Userform Combobox | 24 Feb 2005 09:47 GMT | 1 |
I have a Userform with a combobox. The combobox should be a list from which the user could choose an option. My question: "How can I get an optionlist in a Userform?"
|
| Email Notification | 24 Feb 2005 09:03 GMT | 1 |
I would like to set up a worksheet with a schedule of bills to be paid and be notified a few days in advance, by email, when the bill is due. Any takers?
|
| Looking for template | 24 Feb 2005 08:23 GMT | 3 |
Looking for a commercial real estate lease vs. own analysis template. Anyone know of one out there?
|
| Retrieving data from a list without skipping rows | 24 Feb 2005 05:22 GMT | 2 |
Given a list with multiple lables in column A and corresponding data in column B, can I generate separate lists for each label in the original list without skipping rows that correspond to other labels in the original list? Example:
|
| Is there an Excel viewer for Windows 98? | 24 Feb 2005 03:20 GMT | 1 |
I'm looking for a viewer so I can see Excel documents. I am running Windows 98.
|
| Changing Row and Column colors | 24 Feb 2005 03:17 GMT | 1 |
Is it possible to change the default color of the Row and Column headings (A,B,C ...., 1,2,3 ...)?
|
| protecting certain parts of worksheets from being changed by mistake | 24 Feb 2005 02:49 GMT | 3 |
I have tried to lock them but this did not work. I need to protect the formulas and some text fields, in different part of the sheets and allow them to enter in cells they are allowed to use. how do I do this, I have looked in the help pages but can not seem to find a
|
| Help with data parsing | 24 Feb 2005 02:03 GMT | 2 |
I have data which is in the format below called "Before Data" and I am trying to get it to "After Data" format. I can do some programming if given some advice. As you notice I am trying to repeat data from
|
| How do I enter a formula in a cell so that letters= a number i.e.. | 24 Feb 2005 01:09 GMT | 3 |
How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.
|
| selecting date range / data range autofilter | 24 Feb 2005 00:21 GMT | 1 |
Is it possible to select rows based on a date range (say from 01-01-2005 to 31-12-2005) from column B: A B C id date value
|
| Drop Down Box - Avoiding Blanks? | 24 Feb 2005 00:11 GMT | 4 |
i am using excel 2003. i have a xls file with over 40 sheets. i have created a list from the column starting on the cell#2 (below the header) and ending to the last cell #65xxx, and named it facility. on another sheet i'm using a drop down box validation to grab that list with ...
|