Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Multi-column combobox - allow text to span columns?01 Sep 2007 00:37 GMT1
I am creating a multi-column combo-box...that I want to basically
mimic the Item combobox in Quickbooks (if anyone is familiar with
that).
The combobox should look as below, where the "category" is column 1,
Using a "SHELL" Command31 Aug 2007 23:49 GMT10
I'm getting an error message that implies that I can't call a procedure on
my system:
"This error can also occur if an attempt is made to call a procedure that
isn't valid on the current platform."
HPageBreak and crazy error (Excel 97)31 Aug 2007 22:58 GMT1
I have the following line of code that produces something I have never
seen before:
   lngHorizBreaks = Worksheets(1).HPageBreaks.Count
When this code executes, it changes the column widths of in the
How can I display a warning if calculations indicate original data may be wrong?31 Aug 2007 22:50 GMT2
Here is my problem.  I need to compare calculated data, and my
spreadsheet program will be used by unskilled people.
There are multiple sets of 3 columns each for input of numbers.  The
action I describe below will take place with the input of as many as
Column Widths31 Aug 2007 22:02 GMT3
Is there a way I can set columns ...
A
D
H
Sending Email via VBA31 Aug 2007 21:46 GMT2
I'm sending an email using VBA via the code listed below.  Everything works
fine, but I'd like to incorporate a hyperlink in the body of the email, which
I don't know how to do.  Right now the link (text) is in the body of the
email, but i do not know how to make it a hyperlink.  ...
Macro syntax problem - Dean31 Aug 2007 21:33 GMT10
I have the following formula in EXCEL (it works)
=H78*PerfPercent*ScalingFactor*C78/SUMIF(F55:F77,"=y",C55:C77)
which I want to have visual basic type into the current cell.
Here is my attempt at writing it in VBA but I am getting a compile error
Accounting Software Import31 Aug 2007 21:22 GMT2
I have a problem that I am finding complex. Basically, I import
numbers from an accounting program that has accounting codes, budget
totals and amount spent, and remaining cash flows for each accounting
code. these numbers arranged in columns with the smallest code at the
Mass File Column Insert and Name31 Aug 2007 21:00 GMT1
I need to create a procedure that will loop through all files in a specified
path, insert a new column in each file called FileName, then write the actual
file name for that file into the column all the way down the list.
How can I accomplish this?
Resize the radio button31 Aug 2007 20:54 GMT2
Is there any way to make the radio button bigger?
Thanks!
cleaning up text macro by Alan Barasch31 Aug 2007 20:21 GMT2
I downloaded from the web at the following site
http://www.xl.barasch.com/ACl12117.htm
code (except for a change I made in the dim statement becasue Mr.
Barasch made an honest mistake by confusing RowCount and CountRow and
User-defined Function With Varible Number of Inputs31 Aug 2007 20:05 GMT1
I am trying to create a VBA function that will take a variable number
of inputs.  Is there a way to declare a variable number of inputs for
a function?  I have found that if I don't use the total number of
inputs declared, I will get #Value.  My thought is that a loop could
If Then and Copy/Paste31 Aug 2007 19:38 GMT4
Good morning,
I am really new at programming in excel -- I've recorded a few macros, but
now I am needing functionality that is going to require me to program
something. I was hoping to find some help...
Problem with Error Handler routing?31 Aug 2007 19:18 GMT4
I have a userform in Excel that requires a user to select an option from a
drop down combobox.  A command button returns the value and opens up another
workbook for the user to edit.  I added an error handling routine that
returns an error message if for some reason the file ...
Finding unique entries in a column31 Aug 2007 19:14 GMT6
I have a range of cell entries,
Worksheets(Sheet1Name).Range(Cells(Sheet1FirstRowNum, _
Sheet1RespCodeColPointer) & ":" & Cells(Sheet1LastRowNum, _
Sheet1RespCodeColPointer))
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.