|
|
drop down selections by
gavmer
Hi all,
I have a problem. I have approximately 100 combo boxes to select items
that are linked to various cells. Each drop down holds 4 items. When i
use the...
|
|
5 |
207 |
|
|
Query not getting the new data by
Eddy
Excel2000, SQL2000, ODBC
I have a spreadsheet with query to import data from a
table but it just won't pickup the new data with the
refresh option. If I...
|
July 1st, 2004 07:46 AM
by Eddy
|
0 |
170 |
|
|
Header & Footer by
vikesh
I often get files from other users who do not maintain the headers &
footers properly.
Is it possible that we adjust the Header and/or Footer for...
|
|
5 |
432 |
|
|
|
|
0 |
690 |
|
|
Macro Question by
Scottmk
Hello everyone,
I have the following Code in Excel:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address "$G$4" Then Exit...
|
|
1 |
201 |
|
|
|
|
1 |
409 |
|
|
Merge and Center Problems by
Lynn
Has anyone experienced problems with the Merge and Center
feature in Excel? If so...what are they? I was told to
avoid this feature because it interferes with...
|
|
2 |
546 |
|
|
|
|
3 |
693 |
|
|
COMPILE ERROR message by
J. J. Levin
I've just installed Excel 2000 on my computer, overwriting my old Excel 95, and
now every time I access the program (or go to shut it down) I get the...
|
|
4 |
224 |
|
|
PageSetup macro calls are slow by
Stan
The code below takes nearly 11 seconds to run; this is on a WinXP with
a P4 at 1.2 GHz, 512MB RAM, oceans of free disk space, and Excel 2002.
Experiments with...
|
|
1 |
245 |
|
|
Expanding Data As Needed by
MT
I am wondering if there is a way to automatically expand a list of data that varys with clients, as needed. For instance, I have an Input Worksheet, where all...
|
|
2 |
627 |
|
|
Strange Tab Key Behavior by
bg18461
I have a userform with about 20-30 textboxes. When users use the tab
key to navigate, it will work, then all of a sudden just stop. The tab
stays inside the...
|
|
1 |
354 |
|
|
getting macros to work in all workbooks by
andy
i have a workbook that i use as a template. i am using the save as option in order not to change any of the data on it. However, whenever i save it under a...
|
|
1 |
201 |
|
|
Macro to hide rows by
markstro
I have a certified payroll spreadsheet in which I want to display only
the employees that have pay data entered that week.
I often unhide all rows, enter data,...
( 1 2)
|
|
14 |
1,106 |
|
|
Combo-box with Choose formula by
Abdul
i am using choose formula with combo box. On the basis of "Cell Link" i
am retriving the figures shown just against the combo box list e.g
abc 100
def ...
|
|
1 |
180 |
|
|
combo box by
alekm
Hi,
how can I put combo box on sheet from which user can pick appropirate month?
Thanx
alekm
|
|
4 |
198 |
|
|
Macro help please: Excel data to word doc by
anna-maria
Hello,
I've read through all of the other posts regarding this matter and it's still not working. Here's my situation:
I have created an excel file in which...
|
June 30th, 2004 11:53 PM
by AlfD
|
5 |
1,602 |
|
|
new book saving & gridline colours by
FJDx
When I open Excel, a new workbook appears called "Book1.xls". On my home
computer, I can go on to close Excel down without it asking me to save
Book1. However,...
|
|
2 |
281 |
|
|
Square Character in Excel (apostrophe) by
Robmo
In coverting and copying data from the Internet into excel, we constantly have square characters appear in a number of places, but in particular in place of...
|
|
3 |
301 |
|
|
Can you create Conditional Validation Lists? by
shadestreet
I apologize for the blank post, I have been having problems accessing
this site through exceltip.com....keeps saying the forums are under
construction.
In any...
|
June 30th, 2004 11:30 PM
by AlfD
|
2 |
387 |