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 / January 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel spreadsheeet16 Jan 2008 15:34 GMT3
I am working in a spreadsheet and somehow I have evidently hit a key that is
incorrect.  My column which should show the results of the formula shows the
formula.  How to I correct this?  HELP?
VBA Module Function???16 Jan 2008 15:34 GMT3
I have programmed the below function into a vba module:
Use a VBA function like the one below
call with
=bonus(b26,b27)
Excel List Box16 Jan 2008 15:29 GMT5
I need help to create a Macro to fill a list box with names from
another sheet and then when the list box changes to activate another
macro that will display some charts.
So far I only have the following code:
Linking Worksheets16 Jan 2008 15:27 GMT1
I have an excel worksheet that the information is populated from an access
query that I created. The information exported from access goes to a template
sheet I created, now I am wondering is there any easy way to link excel
ranges from one worksheet to another, possibly ...
Excel Sorting - Finding Duplicate Entries16 Jan 2008 15:22 GMT1
I have two Excel Spreadsheet with client names.  But I want to find  the
duplicates and create one file.
Is this possible without having to go through all 900 names?
Thank you
Combining two ideas?16 Jan 2008 15:06 GMT3
Thanks to the NG, I'm able to open file(s) into my CURRENT workbook
this way...
   If Fnum > 0 Then
       For Fnum = LBound(MyFiles) To UBound(MyFiles)
Macros do not run when spreadsheet is used on a different computer16 Jan 2008 15:01 GMT6
I created spreadsheets with multiple Macros. When I transfer the spreadsheets
to other computers sometimes the Macros do simple not run at all or the
debugger comes on or create error messages or even more confusing some Macros
in the same spreadsheet run no problem. Some users ...
Complex macro issue16 Jan 2008 14:58 GMT2
I have a very big spreadsheet which is divided out in job areas…there are 20
or so job areas and each job area has a few roles in it (can be between 5-10)
or maybe more. This information needs to be copied from this sheet into 20
other sheets (so each job area goes into a new ...
cell change16 Jan 2008 14:56 GMT8
I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
   On Error GoTo stoppit
       Application.EnableEvents = False
Formula to ask what Time/Date it is.16 Jan 2008 14:38 GMT5
Do you have any ideas what formula I could put together to set up the
following criteria:
Purpose:  to determine what time/date a cell is populated with.
Action:  If the date & time are < 14:00 then put today's date, if it's after
Comparing 2 different work books16 Jan 2008 14:38 GMT1
If I want to compare 2 word docs and highlight the differences between them
I use:
Sub IsDocument_Equal()
Dim oDoc1 As Word.Document
Range Formula16 Jan 2008 14:35 GMT5
I need help, I am trying to do a bonus calculation for Budget and Atual sales.
In b26 i have actual sales and in b27 budget.
Here is what i am trying to do.
Budgeted Unit sales bonus
Spin button16 Jan 2008 14:29 GMT2
Hiya
How do you use the spin button? Arrow up arrow down ... hmm could be
useful. Anyone got a quick tutorial on increasing and decreasing a cell by
+1 and -1 ?
Selecting the secon column of a separate range16 Jan 2008 14:25 GMT3
Hello, I'm working with graphs, what I want to do is a kind of difficult to
explain, I hope you understand what I'm trying to say.
I have The following data:
             a                 b                c                    d
Automatic calling of a macro16 Jan 2008 14:25 GMT4
I would like to know if there is a way to call a macro to run when a
particular cell, say A1 on Sheet1 for ease, is changed.  A1 will be changed
by a formula calculation, not by a user hard coding an input.  I currently
have a button to call the macro and do its thing, but I ...
 
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.