First  |  Prev |  Next  |  Last
Pages: 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196
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
First  |  Prev |  Next  |  Last
Pages: 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196