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 / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
move to the cell on the right, my code not working pls help17 Apr 2007 03:48 GMT5
Pls assist me. Thank you.
My macro will move to the cell on the right when the current cell is
occupied & stop once it has been set to the new empty cell.
Sample of my data
NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS17 Apr 2007 03:38 GMT1
NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS
I'd like some help with these problems
1)    I want to get a command button on a userform in sheet 1
           to
if condition is met, shade cell [WORKS] but if value changes: erro17 Apr 2007 03:10 GMT4
ok, thanks to this here site:
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm
and help from u guys, i've figured out how to shade cells based on conditions.
(I couldnt use Conditional Format becuz there was more than 3 conditions)
Charts Sheets to Powerpoint17 Apr 2007 02:38 GMT1
I am using some code I got from a friend and it only appears to work
for embedded chart objects? I would like it to work for Charts that
are in the Chart Sheet format.
Any Suggestions?
Sub to transform table into cols17 Apr 2007 00:20 GMT5
Source table is in sheet: V, cols A across to D ... ,
col headers in row1, data from row2 down, viz
Cust# Visit01 Visit02 Visit03 ... Visit200
Cust001 Date01 Date03
Scheduling by workdays only spreadsheet problem16 Apr 2007 23:55 GMT3
I need to create a spreadsheet which calculates project mileposts.
Start date | Est. workdays | Est ready date               Est ready
date allowing for weekends
A1           | B1                  | A1+B1                         |
Recording a range of changed cells.16 Apr 2007 23:36 GMT2
I have some sheets that I need to note if any of the columns within a given
row has been changed.  To clarify columns A1:Q1 have data which can be
changed, I'd like to have cell Srow# set to True if anyone of the items in
column A-Q have been changed.
filling a combo box with two Columns16 Apr 2007 22:42 GMT8
How can I fill a Combo Box with two Columns?
Using ComboBox1.AddItem seems to only accept one column?
This is what I want the Combo Box to contain:
   1    Dough Petersen
tabbing in code16 Apr 2007 22:30 GMT4
is there anyway to line up my code automatically?
Create Harvey Balls in Excel?16 Apr 2007 22:15 GMT1
How would I create Harvey Balls in Excel? (Circles full, half full etc that I
can use in a drop down selection menu)
Creating a macro to swap cells but retain formatting16 Apr 2007 22:14 GMT3
I have a macro that I am using to swap the contents of two cells.  When I
use it I lose any character formatting that I have applied to the cell(s).
Does anyone have any insights into how to do a swap cell macro but retain
the formatting?
Coding a filename into a macro16 Apr 2007 21:54 GMT1
I want to be able to move a selection of sheets to a new workbook, and
name the file (this does not change so I would declare this as a
string - I think), however, I would like the newly created file to be
saved in the current directory (the directory of the original file).
Print Preview + Coordinate Problem16 Apr 2007 21:45 GMT1
I'm having a trouble with Excel 2003, and I've looked for an answer
all day without success, so I thought someone could help me.
We have a workbook containing lots of info the user needs to fill. To
help the user, some of those sheets have a QuickHelp routine - an "?"
Lock cell and reprotect sheet after save16 Apr 2007 21:09 GMT2
I have a spreadsheet that tracks performance.  Some info is put in by many
different users.  Other info is put in by our Admin team.  All the cells that
our Admin team updates is locked and the sheet is always protected.  
Is there a macro that will lock the cells that the users ...
want to advanced to cell on the right but my code won't work16 Apr 2007 20:56 GMT1
What my macro should do is move to the next cell to the right when the
current cell is occuiped.
sample of my data
    A1       A2
 
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.