Programming

Selecting from Worksheet to fill combo boxes on User Form
I have a user form with 3 combo boxes that are for selecting customer information. Combo boxes are as follows: Customer_11 State_11 CLLI_Code_11 In the User Form Workbook I have a worksheet set up for each cumstomer that has the customer info in it Name, Address, Zip, etc.... Customer1 Customer2 Custome... 18 Feb 2010 00:42

Replicate Pressing Shift Button with SendKeys
Is it possible to replicate pressing the SHIFT button with SendKeys? Not by using the plus (+) sign. I need to use it with an AS400 system and the plus sign isn't working. I need to replicate the SHIFT button on the keyboard. I appreciate your help. Thanks Steve ... 16 Feb 2010 12:57

Run macro on column insert or delete
Is there a way to trigger a macro to run any time someone inserts or deletes a row? ... 15 Feb 2010 17:48

Error on Code
Hi, I am using the code below to stop the wrong users inserting / deleting rows or columns. Problem is it works once, but if it is tried twice it fails at the .Undo point in the code. Any Ideas? Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim Msg As String Dim pWord As ... 15 Feb 2010 17:48

Selection autofill
Hi, Can I please have some help with the following code. Range("A4").Select Selection.AutoFill Destination:=Range("A5", (("NETDAYS"))).Value NETDAYS is a named range that for demo purposes holds a value of "A20", so the range to fill is A5:NETDAYS. But something is wrong that I can't figure out. Thank... 16 Feb 2010 18:23

Run-time error '380'
Back in 2003 I created a macro for a form that was working fine. I haven't used it since but now that I need it, I get all these strange errors that I am sure where not there back in 2003 (e.g. I had to in include VBA in the following line: txtBirth.Value = VBA.Format(spnBirth.Value, "d-mmm-yyyy") Now my pro... 15 Feb 2010 14:21

xlDialogPrint arguments
Can someone tell me how to disable the "Print Preview" button in the xlDialogPrint dialog? Thanks, ... 15 Feb 2010 13:14

Formatting 1 cell depending on a value of another.
Heres what I have: I have 1 sheet called TeamData and another sheet called MonthlyGain I want to format cells on MonthlyGain dependent on the values of cells on TeamData. Cells on TeamData are either numbers or blank cells. Heres the 1st cell and what I want it to do. I want MonthlyGain!A7 to, if TeamData!C2... 15 Feb 2010 13:14

Help file
Hi Once I had a help file for all options in ole automation for word and one for excel. Where can I get such files? WBR Sonnich (sorry I posted the same in word, should have been one post only¨) ... 15 Feb 2010 09:50

Rename filename.csv
Hi, I am wanting to use some OpenText code to open a file but the file is currently named with an CSV extension. Whilst I could go to File Manager and rename this with a TXT extension, I'd like to do this from within Excel or create a copy and name it with a TXT extension. Is this possible? Thanks, Rob ... 15 Feb 2010 12:05