Putting formulas in Private Sub Worksheet_Change(ByVal Target As Range)
Instead of dragging down your formulas the standard way on the
spreadsheet itself. How would you inplement the code in the Worksheet
itself. I'd like for... Once A3 has a date input, for all the formulas
to be automatically pasted into that same row. Once A4 has a date and
so on. "D" thru "K" all have formulas in them. Thanks in advance!!
You could do that but might be easier if you use no code at all.
In D1:K1 enter =IF($A3="","",your formula)
Drag all down as far as you wish.
Only have to do this once.
Gord Dibben MS Excel MVP
On Sun, ...System Menu for Dialog w/out Caption
I am using a custom dialog w/out caption. I draw the caption in OnPaint with
buttons for minimize, maximize and close.
Dialog styles have POPUP, Show System Menu and Show in Taskbar set in
resource template. Dialog do not have any parent window.
On InitDialog I do this
CMenu* pSysMenu = GetSystemMenu(FALSE);
if (pSysMenu != NULL)
...Programmatically Minimizing my App?
How can I programmatically Minimizing my App?
::ShowWindow( hWnd, SW_SHOWMINIMIZED /* or SW_FORCEMINIMIZE in W2K &
XP */ );
Check Abdoul [ VC++ MVP ]
"Scott Metzger" <NOSPAMScott.Metzger@york.com> wrote in message
> How can I programmatically Minimizing my App?
> Scott Metzger
...Create Requisitions Programmatically
I need some help creating Requisitions programmatically. Here is the process
that we want to follow.
1.. Vendors drop their files in a directory
2.. The program reads the files and performs some validations.
3.. A new Requisition should created automatically
Can someone please give me some guidance and where possible some sample code
to perform the above. I am strong in .NET development but is a newbie in GP.
I have the development environment setup and is going through eConnect
All help is greatly appreciated.
...Creating popup-menu on the fly
I'd like to create a popup menu (in a dialog) on the fly. Everythings
works fine, but there is one problem, all the items are greyed. What is
the reason for this.
Here the code-snippets (mfuncMenu and m_contextMenu are Dialog-defined
vars of CMenu)
m_funcMenu.AppendMenu(MF_STRING, 1, (LPCTSTR) "SubItem1");
m_funcMenu.AppendMenu(MF_STRING, 2, (LPCTSTR) "SubItem2");
m_contextMenu.AppendMenu(MF_POPUP, (UINT) m_funcMenu.m_hMenu,
(LPCTSTR) &...GP 10 Windows not able to expand
Has anyone had an issue with some of the windows not beign able to be
expanded? I have not had any issues on the test environment with 10 no
service pack. We did an upgrade for a client and they needed service pack 1
and they have a few windows that can't be expanded. Just wodnering if anyone
else has this issue.
There have always been a few windows that did not expand. One I ran into
today in V10 no service pack was the 1099 setup window.
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsl...Sub-categories on the X axis
I am trying to graph data from various schools and want to display data from
2002-03, 2003-04, 2004-05 and so on with the school name under that range of
dates. I only want the school name to appear once. The data adjacent to
those dates had the school name repeated for each year but when I merge the
repeated school names into one field the chart now show only one school name
but it is directly under the first data point. I want it to be centered
under the dates associated with that particular school.
Thanks for your help.
What version of Excel? In 97 the behavior was as you describe...Tab sequence programmatically..
I have a button which added dynamically to a property
sheet. Now for setting the tab sequence with this new
button, Am using SetWindowPos() method. Now tab sequence
THE PROBLEM IS
Through the arrow keys, I could not navigate to the last
button for which I called SetWindowPos. where as through
tab keys I could go to the last control. I will appreciate
ur help in this.
I have three buttons (OK,Cancel, Help)on the property
sheet. I added a button "Default" to the property sheet
and positioned between Cancel and Help. I set the tab
sequence as ...Combo box in sub-form
To John W Vinson:
Any chance of an answer to my previous question, as follows? I really would
appreciate your help; you're my last hope!
> On Sun, 29 Nov 2009 12:21:01 -0800, Chris <Chris@discussions.microsoft.com>
> >I have a Track Artists table with field headings: Track Artist ID, Track
> >Artist, Recording ID & Track ID. There are 3 names entered.
> >When I click on a Track Artist field in the Sub-forn, a down arrow appears.
> >If I click on the arrow a drop-down list appears but it is empty. When I
> >double clic...Menu & Tool bars in outlook
I've added a button to both the global menu bar and application level tool
bar. They appear perfectly in IE, but not in Outlook. What have I forgotten?
I've got web.config set to:
<add key="ISVIntegration" value="All"/>
- <ToolBar ValidForCreate="0" ValidForUpdate="1">
<Button Title="Acumen" ToolTip="Acumen Enquiries"
WinParams="dialogHeight:600px...How to Lock VBProject Programmatically without SendKeys (Note:- I don't want to Unlock or crack the VBProject. Just want to Lock it Programmatically)
Hi all, I got macro in which I can Lock VBProject with SendKeys. But
problem with SendKeys that they not work on every User's Computer and
Users can see all the hard work which I put to create my macros. I
tried to search for the sultion but I came across with the comments
that its not available because of the security issues. Well i want to
say that i don't want to Unlock or Cract the VBProject. I just want
to Lock it Programmatically. If there is no sultion then its my
message to Microsoft that they should at least put this function also
that you can secure your Macros o...Executing sub from form code
I have a userform. On the form I have a button that's
named "cmdok". In the form's code I have this sub:
Make_CSVs is a sub in one of my modules. My code bombs
although I can run Make_CSVs by itself and it runs fine.
Can someone tell me what I'm doing wrong? Thx.
What does "my code bombs" mean -
Do you get a run-time error? A compler error? A crash?
Is your Make_CSV's routine started, but something interrupts?
Is your Make_CSV's sub in a regular code module (which it should be)?
In article <166901c3f...My file menu is not on the menu bar.
The file menu has mysteriously disappeared from the menu bar in Word 2003
(Student and Teacher edition). Is there any way to get it back? I've tried
both View>Toolbars>Customize and Tools>Customize.
What you say you've tried isn't clear. Have you, in Customize, Toolbars
tab, clicked the checkbox in "Worksheet Menu bar?" You want the checkbox,
not just a blue selection bar across it.
mvpearl omitthisword at verizon period net
"karyn slm" <karyn email@example.com...Options Choice in Tools Menu
Word 2003 - The 'Options' choice in the 'Tools' Menu has disappeared. Anyone
know how to get it back. I have found an answer for Word 2007 but not Word
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"tess" <firstname.lastname@example.org> wrote in message
> Word 2003 - The 'Options' choice in the 'Tools' Menu has disappeared.
> ...How to gracefully (programmatically) kill an app?
I have an app that runs 24x7. Occasionally (after a few weeks or so) the
main UI thread hangs on an odd machine. I have not been able to duplicate
the problem in the lab. As a temporary solution I'm thinking of killing the
app when it is detected that the thread is hung. The problem is that I
can't find a way of killing it gracefully - i.e. like a task manager. I
would not like to see any popups from CRT library or from the OS when the
app is killed.
I'd appreciate _any_suggestions.
This is the simple way to close one ap...Scrolling to show sub-folders when opening folders
Every other version of Outlook I have had scrolls up or
down to show all the subfolders in an opened folder.
2003 is inert. If you open a folder at the bottom of the
window, all the subfolders become "visible" off the
bottom of the screen, and you have to scroll down
manually to find them.
When filing 100 or more e-mails per day, this wastes an
extraordinary amounbt of time. PLEASE, is there any way
to regain the 'auto-scroll-into-visible-window' feature
Outlook has always had in the past?
...save as programmatically
I am using Visio 2003. And I am opening pre-Visio 2003 documents
programmatically. When I save I get prompted with a dialog. How can I stop
this? I am doig this programmatically. Why would it be prompting me.
Looking at the object browser I see...
Save, SaveAs, SaveAsEx. But none seem to have the values I would need.
Even SaveAsEx only has these options:
The document is saved as read-only.
The current workspace is saved with the file.
The document is included in the Most Recently Used (MRU) list. By defau...Pull down menues with automatic values
Well this is my first time here and the first time i have known abou
Im not into Excel as a use on a daily base scenario, but i have got t
use it a lot in my University course from now on.
Ive been asked to produce a spreadsheet which will allow a user t
create their own computer. The user HAS to select certain component
like motherboard, hard drive, processor etc.
Beside each component there should be a drop down list to give the use
a wide choice of products relating to the component, then when the
select what they want, the price of that component should show u
beside the com...backgound menu color
In the IE on XP the backgound color of the menu bar has turned black, so i
read the menu items as they are black text on black backrgound.
How ca I resolve this problem?
Zan Pule wrote:
> In the IE on XP the backgound color of the menu bar has turned black,
> so i can't
> read the menu items as they are black text on black backrgound.
> How ca I resolve this problem?
> Thank you
Active - and maybe Inctive - Title bar in the "Item" box.
...Changing programmatically the color of a row #4
> once you have the conditional format set correctly all you have to do is
> rightclick on the mouse, copy, highlight the destination cells, paste
> special, formats.
> Or alternatively double click the "format painter" icon and highlight
> the destination cells/rows and leftclick to paste
Very thaks to all!
I have already sloved the problem...
Thanks for the help :p
masterx81's Profile: http://www.excelforum.com/member.php?action...Open Subform on main menu to show specific date
I have created a menu form which has a subform in it and what I want to do to
is the following:
When the Main Menu opens I want the subform to open to a specific record.
The Main Menu has a field called 'Turnover Date' and so does the sub-form.
I want to open the sub-form so that the Turnover Dates match or if there is
no matching date in the sub-form then open a blank record for the subform.
I know it can be done, I just can not remember how to do it.
Any help would be greatly appreciated.
in the subform control within the main form, set the LinkChildFields and
LinkMast...Programmatically Posting a Receipt to the Journal
I've searched various sources and read endless documentation, but I'm still
at a loss of how to solve this one. In essence I require to complete a
transaction without any cashier interaction, including posting of the
receipt, which is the stumbling block.
Programmatically, I can find a select the correct XML template from the
database, I can also post 'basic' XML to the journal. The issue is tieing
the 2 together, so that the contents of the journal are exactly what the
customer would expect from their template.
Afaik the journal 'receiptcompressed' field c...Expand formula in EXCEL
Is it possible someway to expand a formula in EXCEL downward, (A1--> A100),
but the values of cells have to be read from a horizontal line? (That means:
A1=B1, A2=C1, A3=D1,…………………….A100=CW1).
I try some forms of $A1, A$1, e.g. (expand) but without any result.
Put in A1
then copy downward
"?????" <@discussions.microsoft.com> wrote in message
> Is it possible someway to expand a formula in EXCEL downward, (A1-->
> but the values of cells hav...move a scroll bar programmatically
I have a form that I am doing several things with programmatically to aid the
data entry user. The form enters new lines of data automatically in response
to user events. The user is taken to a record in a subform where the user
needs to enter data. Sometimes, depending on the task and data present, the
user is taken to the next to last record; however, the scroll bar stops short
and the user thinks this is the last record. I need a way to nudge the
scrollbar down a line or two programmatically. Is this possible?
Thank you in advance.
>I have a form tha...Viso save as menu does not contain the file formats shown in help
I need to export my visio drawing to a web page (Visio 2003). Viso Help says
to use save as and select an export file type from the file type drop-down
list. My visio does not contain any choices other than standard visio
formats. What is wrong?
Another option in Visio 2003 to save your drawing as a web page is the Save
as Web Page... command on the File menu.
Web Page (*.htm, *.html) should be listed as a choice in the Save As dialog
in the Save As Type control, and there should be several non-Visio save as
types available in the dialog, as with other...