Textbox Data IsNumeric
Mon, 13 Oct 2008 10:44:00 -0700
I guess we all know that IsNumeric does not work 100% of the time when used
with Userform Textboxes. This is the format that I am looking for from the
users #####-# or ADT##-#. How can I ensure I have this format? This is what
I have so far:
' must have correct Item # to apply to schedule
If L ...
|
Search workbook for cells with white font
Mon, 13 Oct 2008 10:39:00 -0700
I'm interested in setting up a macro that will have similar functionality as
the Ctrl+F command. Except I need the macro to search the entire workbook
for any cells with white font. I'm guessing that this would not take too
much code to do, but I'm limited to macros I can record. Any help would be
appreci ...
|
Protected Data>Lists - and no VBA?
Mon, 13 Oct 2008 10:18:31 -0700
I asked this question the other day in the straight Excel group, but thought
I'd try again here.
I've never used the Lists much that are available by clicking Data>List.
They seem like they'd be a great way to bypass lots of VBA if you can insert
and delete rows while protecting the worksheet. However, it ...
|
Range.Delete Shift causing merged cells to unmerge
Mon, 13 Oct 2008 10:10:05 -0700
Greetings! In over 300 executions, the following code never failed nor
displayed a message:
' The follwg instructions will delete the first 28 rows:
Application.Goto Reference:="R1:R28"
Selection.Delete Shift:=xlUp
But when I revised the code as follows (hoping for greater speed):
...
|
Formula to Find First Cell in a Row with Values
Mon, 13 Oct 2008 10:00:25 -0700 (PDT)
Hello, I am trying to find the value in a series of cash flows that is
the first month to have a cash flow. I have the formula to find the
max, which is =SUMPRODUCT((MAX(($a2:$z2>0)*($a$1:$z$1)))), (thank you
Rick Rothstein!)where row 2 equals the cash flow and row 1 equals the
corresponding date.
I am now lo ...
|
Need help with respect to CDialog-based display of dialog in Excel
through xll
Mon, 13 Oct 2008 09:59:06 -0700 (PDT)
Can anyone out there tell me how to display a CDialog-based dialog
control from within XLL. I have managed to cratee an MFC extension
XLL (i.e., originally dll but tweaked to become xll). I have
different NON-VISUAL functions and commands that can be used from
within excel spreadsheet and excel menus, but I ca ...
|
Any ideas?
Mon, 13 Oct 2008 09:59:09 -0700
The following code worked fine until I added checkboxes from the Control
Toolobox in cells from G3:O562:
Private Sub CommandButton1_Click()
' Start New Checklist Button
Sheets("sheet3").Range("a2:a21").Value = "FALSE"
Sheets("sheet3").Range("C2:C6").Value = "FALSE"
Sheets("Checklist").Rows("3:562").Entire ...
|
|
|
Quick method to sort a list of strings?
Mon, 13 Oct 2008 12:10:39 -0400
I have code that was written (to my internal customer specifications) which
would churn through a list of information and populate a report worksheet.
Part of the report is that the code adds comments to different cells; each
cell may have no comment at all, a single line comment, or multiple lines of
comm ...
|
Change Colors in Charts
Mon, 13 Oct 2008 08:58:01 -0700
Hello, I'm looking the equivelent in c++ for the following VBA code:
Sub change_series_color()
Set ch = Worksheets(1).ChartObjects(1)
Set objSeries = ch.Chart.SeriesCollection(1)
objSeries.Interior.Color = RGB(255, 127, 0)
End Sub
I can get the SeriesCollection of the chart, however, the Series ...
|
Dsiable right click on objects
Mon, 13 Oct 2008 08:12:01 -0700
Any code disable right clicking on objects. Have use 'ply' for right clicks
everywhere else!
Cheers
G ...
|
