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
Need help creating VBA procedure for Open event17 Aug 2007 02:20 GMT1
I need to create a VBA procedure for the Open event of a workbook that will
check to see if the macro security level is set to High, and if so, display a
message advising the user to change the macro security level to Medium.
Being a novice to VBA, can someone please show me how ...
Macro Not Completely Working17 Aug 2007 02:19 GMT2
As you can see this macro should find a number less than 1000 and then color
it.
It finds the number, however will not color it, and also there may be
multiple cells with less than 1000.  Could you help me in getting this macro
last cell without a blank17 Aug 2007 02:18 GMT6
I have a series of dates in cells a1:z1 and some numeric data in some of the
cells a2:z32.  I would like to find the last column that contains a value in
any of the data cells (all columns after that contain a blank) and then
select the date cell that corresponds to it.  Can ...
using checkbox to calculate another cell17 Aug 2007 02:18 GMT2
I have the following code in a macro for a checkbox and it gives a error of
object required  any suggestions?
Private Sub CheckBox19_Click()
If CheckBox19.Value = True Then
Flash Screen/Timeout msg box17 Aug 2007 02:17 GMT2
I would like to create a flash screen window/message box/popup window
which will close close automatically after specified time, how do I
create it give me a basic idea.
Thanks and Regards
How to org my questions17 Aug 2007 02:14 GMT1
I want to have a way to quickly find the questions I asked on the discussion
group, is it possible to build a personal folder?
Clara
Problems using Worksheet_Change17 Aug 2007 02:13 GMT1
Does someone knows if exist any way of getting the old value in this:
Private Sub Worksheet_Change(ByVal Target As Range)
  ‘ for the new data coming is easy:
 New_data = Target.Value
Simple Custom Function???17 Aug 2007 02:10 GMT1
I'm trying to create a simple custom function. I'm trying to have the user
input the row and column numbers in the function (like =MYFUN(1,2)
referencing cell B1) and have it return the contents of that cell. So I
thought I would use the following.
print/save macros17 Aug 2007 02:09 GMT2
My print macro is currently like this
Sub FinalOrderPrintWorkbook()
   Dim sht As Worksheet
       For Each sht In ActiveWorkbook.Worksheets
Hide a worksheet17 Aug 2007 02:09 GMT3
I'd like to be able to hide a worksheet that I am using for data storage, how
can I do this programmatically? Using the Excel menus?
Signature

Email address is not valid.

Using formula in code17 Aug 2007 02:09 GMT1
I have the following formula which works fine in a worksheet:
=IF(AND(N4>-1,N4<31)=TRUE,"1-30",IF(AND(N4>30,N4<61)=TRUE,"31-60",IF(AND(N4>60,N4<100)=TRUE,"61-99",IF(N4>99=TRUE,"100+","Error!"))))
However, when I try to use VBA code to enter the formula using this ( which
is ...
screenupdating problem17 Aug 2007 02:08 GMT1
I have a macro in the following layout

> sub MyMacro()
>     application.screenupdating = false
Want VB form to show in Excel Worksheet17 Aug 2007 02:08 GMT1
Through the VB attached with Excel, I have built a form for users to fill
out. I need to know how to make the form visible in an Excel worksheet so
that when they open the excel file, the form is visible right away on the
first worksheet.
Picture Problems17 Aug 2007 02:07 GMT1
Just wondering I have multiple worksheets and on the main worksheet screen is
my invoice page, all the rest is programming related.  Now depeneding on the
customer I want them to be able to click on a number and then their logo come
onto the page at the bottom of the screen.  I ...
if statement17 Aug 2007 02:07 GMT1
I would like help writing some code that would run the code below if the
value of cell a5 is the word "Fixed".
Rows("5:13").Select
Selection.EntireRow.Hidden = True
 
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.