List Box and with date VB code
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("f6:f100"), Target) Is
If Target <> "" Then
Target.Offset(0, 1) = Date
Target.Offset(0, 1).NumberFormat = "mm/dd/yy"
Target.Offset(0, 1) = ""
The above is VB code that I have in my worksheet. I have
included validation in the form of a list box in column
F. When an item is selected the date does not fill but
when you type in the first letter of one of the items in
the list box it will appear. How can I get the date...TAB KEYS
Everytime I hit my tab key to go to the next right hand
column, it goes straight down to the right end of the
spreadsheet instead. How do I fix this?
Thank you in advance.
tools, options, transition keys, turn off all Lotus 1-2-3 transition aides.
...I have just set up MS Outlook 2007 and can't send email messages
I have just set up MS Outlook 2007 and can't send email messages ... I
receive error message # 80042109, cannot connect to outgoing server. I
receive email messages without a problem but my outgoing messages are sitting
in my outbox. I have checked with my ISP providr and they believe I have set
up Outlook correctly. Can anyone please help?
Post the complete error message as per verbatim
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be acknowledged.
"FCDECOSTANZO" <FCDECOSTANZO@discussio...excel product key is not working
i'm trying to upgrade my excel from 2000 to 2002 but when the installer
prompted me to enter the product key. i input the product key but it's not
...How can I enter a cell in excel with hotkey or combination off key
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"theo passier" <theo email@example.com> wrote in message
...How do I set email to be received by date?
I want my Microsoft email to arrive on the list via current date with a
preview. It used to be that way and suddenly changed. Help please.
"Grace and peace be yours in abundance" . . . . .2 Peter 1.2 . .
View | Sort By | Sent.
View | Layout | Show Preview Pane.
Imperial Beach, CA
"bhappy41b" <firstname.lastname@example.org> wrote in message
>I want my Microsoft email to arrive on the list via current date with a
> pr...Excel shortcut key "Cut" Ctrl+X come up a formula to me why?
When I use keyboard shortcut key Ctrl+X (Cut) and come up a formula that
=+"upper cell" and can't be undo. Is there any way I can set my short cut
key for "Cut & Paste"?
That sounds like you have a Macro that's been allocated the Ctrl+X
If that's causing you difficulty, you could re-allocate the Macro's
shortcut key, or even delete the macro entirely if you no longer have
any use for it.
"Tony" <Tony@discussions.microsoft.com> wrote in message
| When I...Get the Exchange 2003 Enterprise pproduct key.
I need to reinstall my Exchange 2003 server.
How can I find my pruduct key on my old server ?
On Fri, 27 Oct 2006 13:15:45 +0200, J. W. <email@example.com> wrote:
>I need to reinstall my Exchange 2003 server.
>How can I find my pruduct key on my old server ?
You'll have to contact your reseller or Microsoft directly if you dont
There are a number of free utilities on the net that will scan your
server to get your cd key. Have used several in the past to get lost
ex2k3 keys for customers.
J. W. wrote:
> I need to reinstall my ...Setting up new exchange user
This is probably a FAQ but I have found no reply.
I have a remote user who gets "all" her settings via DHCP from her ISP.
("All" ~ IP, DNS etc)
We set up a VPN from her to us.
In the mail set-up she types in the IP of our server (192.168.x.x) and
Presses Check names - is prompted for password and the IP is replaced with
the servername like "FOO" (and not foo.abz.com). So far so good.
But when she starts Outlook it can not find the server "FOO" - the netbios
Obviously the name resolution fails. Now and then it works. But more o...Outlook 2003 Security Settings
I just upgraded from Outlook 2002 to Outlook 2003. In
Outlook 2000 and 2002 there was the concept of Outlook
Security Folder and the Outlook 10 Security folders that
were setup in the Public folders to allow Outlook to
determine (by registry setting) if the default security
settings for Outlook were to be used or if Outlook should
look to the Outlook Security folders.
Does the concept of Outlook or Outlook 10 security folders
still exist with Outlook 2003? If so where can I find the
administration download for this?
...How to output ascii code to serial port?
I am trying to output ascii codes of non-printing characters to a serial
port, I know their ascii code, but don't know how to do that. Which sytax
does that in C++ or MFC?
If you need to output character, let's say, 1-10, the syntax is
which generates a string of 8-bit characters terminated with a \x00 (NUL) character.
The syntax for a character in a string, single-or-double-quoted, is one of several forms
\r carriage return
\a alert (ding!)
\v v...Set It Up Again?
I've been using Money for years, currently Money 2004. When Microsoft
advised that the direct electronic banking support was going to expire, that
didn't bother me since I don't use those functions. Suddenly (Today) when I
go to Money it want me to set it up like a new subscriber. Can someone tell
me how to get it back the way it was (with all my account entries), or do I
have to go through the rigamarole of setting up all the accounts and then
recovering from by backups?
In microsoft.public.money, camaz wrote:
>I've been using Money for years, currently Money 20...Outlook Group Policy Setting Not Working
I am using the Outlk11.adm group policy template and cannot configure one
setting. The "Minimize Outlook to System Tray" does not work through group
policy or the Custom Installation Wizard. The registry key never gets
created. Can someone help?
...how can i select all the cells with same color on a sheet if there are multipale colors by vba code
how can i select all the cells with same color on a sheet if there are
multipale colors by vba code
Much better than the 1st post. try this
For Each cel In ActiveSheet.UsedRange
If cel.Interior.ColorIndex = 6 Then
mystr = mystr & cel.Address & ","
mystr = Left(mystr, Len(mystr) - 1)
"uobt" <firstname.lastname@example.org> wrote in message
> how can i select all the cells with same color on a shee...Set Receive Message Size for Individual Mailbox
I am trying to increase the Maximum Receive Message Size for an
individual mailbox to 20MB, so this one account can receive large
attachments from external senders. I did the obvious change in the
"Mail Flow Settings --> Message Size Restrictions" in the mailbox's
property, but I still get a NDR saying size exceeds fixed maximum.
It seems like the email is being rejected before it even gets to check
the individual mailbox's property. Any advice?
You probably have lower limits somewhere along the message's path. Here's a
gui...Figuring sql server version via code
Is it possible to check in .net;
1. If sql server 2008 express is installed on a machine?
2. The name of sql server 2008 express instance or instances?
3. If a particular sql server 2008 express instance contains a specific
You can use several methods to enumerate SQL Server instances. Here are a
To determine whether a specific instance contains a certain database, you
can connect to the instance's master databa...Report codes for Matrix Parent
I'm preparing for an upgrade from QS2000 and would like to know if th
following is possible. I'm testing the demo version of RMS an
imported my database. I'm a shoe and apparel store and matrixes ar
very important to us. My reseller has recommended the Retail Real
Fashion bundle, but I would like to try something else in th
I've modified a Detailed Item Sales report and would like to ad
columns for the following items associated with the Matrix Paren
Matrix Lookup Cod
Matrix Dimension 1 (I want to see the value associated with Chil
I...Outlook XP dialogs cut off
Some of the settings dialog boxes seem to be cut off to
where some buttons or input fields do not show
completely. I have a large (20.5") LCD set to the native
resolution of 1600x1200 so every box should be at full
size. I can not find an answer to this in the either the
knowledge base or the Outlook support center.
I am running Windows XP Pro SP1 with Office XP Pro.
what specific dialogs and are they resizable?
Diane Poremsky [MVP - Outlook]
http://www.poremsky.com - http://www.cdolive.com
Outlook Tips: http://www.outlook-tips.net/
Expert Zone http://www.microsoft.com/windowsx...Settings Button (administrator features) Missing in Web Brower Cli
The Settings option in the web Browser client is missing on one machine but
not on others.
I deleted the cookies and restarted the browser and the Setting Button
Does anyone have a suggestion for how to correct the problem without
deleting all cookies?
I have noticed this too. It is very frustrating. I have read a post that
says that this is a conflict between the web client and the outlook client.
I think that the outlook client creates the cookie so that settings does not
appear in the web client and not the outlook client. Supposedly this woul...Add chart
Can anybody find what is wrong with this code? It will just make a
empty chartobject. I believe the ranges are ok, it probably is some bad
syntax or object reference...
The code should make a chart with two series of xlColumnClustered and
one serie of xlLineMarkers.
Dim cht As Chart
Set cht = Sheet1.ChartObjects("R_CF").Chart
On Error Resume Next '(if no chartobject)
On Error GoTo EndCode
'Left and Top location = named ranges
With Shee...How do I change the e-mail I orginally set up outlook with?
Not sure what your question is. Do you mean you want to change your email
"Sledge24" <Sledge24@discussions.microsoft.com> wrote in message
...How to set up 2 diferent prices for 1 product?
I need to set up special pricing for product.
For example i sell bananas by 5$, but when they get not look good then I
want to sell it by 1$.
How to create the pricing mechanism for this situation. It’s not a special
sales price because in the same time I can sell good bananas for a regular
Ho to resolve that pricing situation in RMS?
On May 2, 8:00 am, Martins <Mart...@discussions.microsoft.com> wrote:
> I need to set up special pricing for product.
> For example i sell bananas by 5$, but when they get not look good then I
> want to se...Journal Settings Won't Stick
Working with Outlook 2007 in a corporate environment and my users want to
turn on journaling for the items in the "Also record files from:" entry. The
user can turn on the setting and it will work with in that session but once
Outlook is closed and reopened the checkboxes are cleared and journaling for
these items stops working.
Anyone have any idea how to fix this?
Anyone have any ideas on this one? Any help would be greatly appreciated.
> Working with Outlook 2007 in a corporate environment and my users want to
>...Setting Split form Window Sizes
I can't get A2007 to remember any Split form window sizes after trying
various options for the last 4 hours I've had enough, this should be simple.
I've got Access options set to overlapping windows.
I've switched off Auto Resize and Fit to Screen.
I've tried saving the form after I've sized it to how I want.
None of the above works - I can nearly get it to work if I set the "Split
Form Orientation" to Datasheet on right, but it's still not how I save it!!!
If I set the "Orientation" to below it's nowhere near and sometimes...Catching Accelerator Key
Is there any way to catch the accelerator key press before the
corresponding menu command message is dispatched?
I have a situation where "Delete" key is assigned to a menu via
accelerator. But in some situations, I create an in-place edit box in
the view, and hence under this situatio, want the "Delete" key to be
handled by the edit box. How do I do it?
It appears to me that the accelerator lookup is done before anything
else. Is that true?
Thank you for help
"Abhijit Patait" <email@example.com> wrote in message