How to test variable for chr values
Wed, 3 Sep 2008 14:25:55 -0700 (PDT)
Hi,
I'm trying to parse a part number for quoting.
The part numbers could be, for example:
21718R22C1210055
21718R100440055
E1801B10031B0403
A1801A10069N0055
A3216S63100N1421
In the following code snippet,
I want to return into a string variable, EntrySize,
for a 217 type part, a certain part of a ...
|
Excel 2000 VBA form questions
Wed, 3 Sep 2008 14:17:02 -0700
I am making a form in Excel 2000 which when double clicking the file will
automatically come up. Because of the different size monitors/LCDs I have
run into a few questions.
1.) is there a way to automatically adjust the form to fit the screen; or
2.) how do you put the scrolls in so people with smaller mon ...
|
view raw sheet code
Wed, 3 Sep 2008 14:17:02 -0700
Hi all.
We're using a sql database program which the public can view water rights
ownership on.
On the internal side we update our records, and then update the database.
We've determined that we can format an Excel worksheet to match the layout
of the ownership page on the database.
We've also noticed tha ...
|
Status Bar Message
Wed, 3 Sep 2008 13:50:14 -0700 (PDT)
After running a simple macro on a worksheet, the status bar reads
"table:1" then "table:2" and finally "table:3". I've never seen this
before. Why is excel displaying these messages?
Thanks ...
|
Excel 2007 formula calculation
Wed, 3 Sep 2008 13:44:16 -0700
have ported great deal of vba code from Excel 2003 to Excel 2007. I am
happy to say that most things worked, even things I thought would not.
However, one issue has stumped me. I have some worksheets that have
slidebars to change some values which in turn feed into the lookup_value and
reference for Hloo ...
|
Match Error Handling
Wed, 3 Sep 2008 13:39:00 -0700
I am referencing a project name in one workbook and using the match function
to find the same in another workbook and returning a number, the row which
the project name was found. What I need to have happen is if there is no
match an error message will pop up telling the user there is no match. My
code keeps ...
|
Word to Excel conversion of addresses
Wed, 03 Sep 2008 15:50:32 -0400
I have a document in word thats got address info in it. The format is
generally:
Storenumber
address1
city, state,zip
opendate
accountnumber
expirationdate
phone
fax
contact name
some have 9 lines, some 10-12 or 13 lines per each. They all though
have roughly the same format, where info exists. ...
|
|
|
Protect sheet but allow user paste
Wed, 3 Sep 2008 12:29:02 -0700
I have a named sheet (Raw Data) where user pastes in data from another
program. Data are copied to a hidden sheet where data are cleaned up for use
by macros. Whenever user changes Raw Data sheet the program offers user
option of updating the hidden sheet. Sometimes updates are just changing a
few cells but ...
|
Radio Button Printing Problems
Wed, 3 Sep 2008 12:18:06 -0700
The 'Control' radio button - when printed - is surrounded by a dark
box ... ugly ... is there any way to change or remove this feature?
Thanks.
...
|
Select Case: Multiple Ranges?
Wed, 3 Sep 2008 11:44:01 -0700
I have 6 named ranges which are columns of data on the same worksheet. When
the user enters a percentage in column C, 1 of the 5 colors appear denoting
status. I have the following Select Case statement that works well for
column C:
Private Sub Worksheet_Change(ByVal BESTDel As Range)
Dim icolor As Integ ...
|
