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
auto set time(now) if criteria=true with no later change25 Apr 2007 00:34 GMT1
I am using excel to manage a continues progress report on a data base of
users. The report includes set of stages that the users are going through.
Each time a define criteria set on (true), the user is moving from one stage
to the next.
Executing a VBA macro from within Excel 97 script24 Apr 2007 23:44 GMT1
I am running Excel 97. I have an application in it that is written in the
macro scripting language. The application works very well. I also have a VBA
macro that works very well when I execute it manually. However, I would like
to execute the VBA macro from within the application ...
Problem with Auto Filter and Macro24 Apr 2007 23:37 GMT1
I have a macro that was rud fine until data was added to one of the tabs. The
data was added to data that was already on the data, at the bottom. The
proble we are having now is that the macro is not seeing these data and even
when we run the auto filter on one of the columns in ...
Selecting data to copy and paste24 Apr 2007 23:26 GMT6
I have a macro that sorts data into the correct order, then I manually copy
and paste into a different application. I would like to write code into the
macro that copies the data after sorting, but the length of the data list is
variable, i.e. sometimes it could be spread from A1 ...
Alternatives to Excel VBA (Query Tables returning more than a million rows)24 Apr 2007 23:17 GMT2
I know how to develop VBA applications in Excel.  I'm trying to
accomplish a simple task:
1) let a user pick some values from a UserForm
2) plug those values into a SQL statement
ComboBox Problems24 Apr 2007 23:08 GMT1
I would like the combo box to have a static set of values, but I don't
know how to do it.  I have tried to use rowsource, but the three cells
I want are not together (D9,J9,D52), is there a way just to type in
the values I want on the list?  Any help would be greatly appreciated.
What's wrong with my code? Thanks24 Apr 2007 22:40 GMT4
I'm using the following macro to format phone numbers from "1234567890" to
"123-456-7890". While this works fine on single cells when I try it on a list
it deletes the numbers and inserts the dashes "--".
What is wrong with this? Thanks.
Excel Prints the Page as a Tiny Little Square24 Apr 2007 22:23 GMT3
Anyone?
Someone sent me an Excel spreadsheet.  Half of the tabs are ok, but
half of them print as a one-inch square floating somewhere on the
page.
relating 2 sheets24 Apr 2007 22:03 GMT2
I have two sheets where I have to drag data from the first sheet to
the second one which plays the role of a report.
I am not being abele to get the exact vlookup formula.
to clear myself take this exapmle,
Control box/Command buttons24 Apr 2007 22:02 GMT6
I understand how to make one but what i do not usderstand is where to put the
code to make other stuff happen. Here is example. I made a  Command Box and
named it Random. I put it in F3 and it is set for a single click. Now what I
want to do is get it to put a random number that ...
Populate A Userform ComboBox24 Apr 2007 21:52 GMT2
I am trying to create a search program for a workbook I have been
working on for sometime.  I have created a userform and included a
number of comboBoxes.  I would like the form to function much like the
conditinal formatting userform.  I would like to have the first
MACROS 224 Apr 2007 21:49 GMT1
Where can I find the STOP RECORDING TOOLBAR??
MACROS24 Apr 2007 20:46 GMT2
I am NOT at all familiar nor cognizant of using macros (with VBE), etc.
In fact, mI am not quite sure what a macro is...although I believe it solves
the problems of repeat and monotonous work in EXCEL.
Will someone please give me a simple instruction on installing a macro,
what does target.offset(0,-1).select mean here?24 Apr 2007 20:38 GMT1
In a small area on my worksheet(A1 to A5), I want to achieve the checklist
effect. That means if I double click one of the cell, if the whole area is
empty(without "X"), then the clicked cell appeared "X", if there is already
"X" in this area, then the doubleclick is ignored, if ...
If Conditional formatting24 Apr 2007 20:34 GMT7
Following is my code, which is used more than once in the Sub.
   Range("F88").Select
   Selection.FormatConditions.Delete
   Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=E88<1"
 
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.