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
Performing Data Transformations17 Aug 2007 13:14 GMT2
On Sheet1 I have the following data:
    Column A = Phase
    Column B = Activity
    Column C = Jan 2007 – Mgmt. Hours
monitor a specified range ( OnChange)17 Aug 2007 13:05 GMT2
is it possible to change/specify the procedure "Worksheet_Change(ByVal
Target as Range)" in an worksheet to a specified Range of Data, for
example E7:E61 (Worksheet_Change("E7:E61") ?
greets
copy cells to end of range in other column17 Aug 2007 12:58 GMT3
I believe this question has been answered previously, but I can't easily
locate the answer.
I wish to copy cell value "Y2" to cells Y3 downward to the last row where a
value exists in column X.
Debug to Output17 Aug 2007 12:54 GMT1
How can I get ...
Debug.Print "For 1 -"; TOP; "there are"; tly; "different lists of"; x;
"numbers."
... to pint in a sheet named "R1" and in Cells B3:whatever please.
radio buttons17 Aug 2007 12:46 GMT1
I have two radio button on a worksheet that I need to hide based on the value
of one of my cells. Right now I hide several rows based on this cell's value
but the radio buttons thta are positioned within that range of rows also need
ot be hidden. Here is how I'm hiding the rows:
Save on sheet shift17 Aug 2007 12:32 GMT2
I am new to this VBA, but i will try to give it a go.
I would like the workbook to be saved when the user shifts away from Sheet1
to be certain that content of Sheet1 is always saved.
I suppose that the piece of code should be placed in a VBA module under the
Inserting blanks17 Aug 2007 12:26 GMT3
I'd like to insert a blank row below any row where the
conditional-format bottom border in the range is dark blue (code
5).  Help appreciated.
=dman=
Calculate cell once (on workbook open)17 Aug 2007 11:50 GMT2
I have a formula that results in the date/time (NOW) a user (network name)
opens the file.
Problem is, any time a change is made this formula is updated with the most
current time. Is there any way that I can make this particular cell calculate
path problem17 Aug 2007 11:42 GMT3
I wrote (with mvp help, of course ;- }) a small app that I have now
installed on my work computer, which is on a network.
The IT guy set a path to drive P for me and that is where all my files and
app are located.
How to encrypt excel pki17 Aug 2007 11:39 GMT1
How do I encrypt an excel file to a pki card or smartcard? I'd like to make
an excel spreadsheet that only staff with a pki card can open!
Signature

Del

How to run macro for 10 seconds and stop?17 Aug 2007 10:06 GMT1
I have a simple countdown spreadsheet, which uses the following macro
to start it
Sub Countdown()
  Do Until Date = "09/30/2007 23:59:59"
Returning Image Details17 Aug 2007 08:37 GMT1
I have a procedure that inserts various images onto a spreadsheet.
I want to be able to select an image (by clicking or maybe right clicking or
double clicking) and have a procedure to return the name of the image object.
For example, if i click on a particular image that was named ...
listbox concatenate17 Aug 2007 07:35 GMT2
I need to figure out the code to concatenate multiple selections from
a list box into one cell with a comma as a divider.
This is what I have pieced together from a few sources so far. I get
an error when running this, so I know it doesn't work. Any help would
Calendar control17 Aug 2007 04:09 GMT1
I have designed a complex Excel spreadsheet app in which I am not the end
user that uses heavy vba including a calendar control. It was designed with
Excel 2003 and will be used on PCs with Excel 2003 and XP. I demonstrated the
app on a PC in which everything worked fine, however ...
excel 200317 Aug 2007 03:46 GMT1
have a question about Excel 2003. I am a programmer but have never used
Excel for
any programming unitl now. (Note the people who setup these spreadsheets,
are long gone).
 
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.