Programming

De selecting a range after a copy and paste is performed
Hi In the below code, I am copying a range from Sheet 1 and with the PasteValues method, I am pasting that range to a cell on Sheet 2. The problem I am having is that I can not "de select" the selected (copied) range on Sheet 1. I have tried doing an ESC using SendKeys but that doesn't seem to want to work. ... 20 Jul 2008 20:41

Get the value of selected text (outside of Excel)?
Fellow programmers, This one is driving me up a wall... Is it possible to get the value of selected text on another program as the value of a textbox on a userform? If so, how is this done? I've looked into the some API code for GetWindowText and WM_GETTEXT but I have been very unsuccessful very quickly. Any ... 20 Jul 2008 23:44

Using Sub RDB_Merge_Data()
I'm using Ron de Bruin's great bit of code to compile data. However, I need the MyPath value to be dynamically generated as the source folder will vary according to the user running the macro. How would I amend the code so that it does not rely on a hard coded value? Many thanks! ... 21 Jul 2008 08:56

license
I want to add a 1 year license renewel warning dialogue to my spreadsheet application. I want the dialogue box to come active after 1 year from the date of the spreadsheet. Ideally i want the date expiration to disable the code i use for a particular form (which starts a new spreadsheet blank), but i dont want... 20 Jul 2008 18:38

Relative Formula References NOT changing After Insert From VB
I'm creating an Excel Workbook from VB and inserting some formulas (from VB into Excel). The formulas are column specific and are relative reference formulas. For example oWB.ActiveSheet.Cells(row, "H").Formula = "=IF(B7=""B"", ((F7-D7) * C7 * 50), ((F7-D7) * C7 * 50))" 'Gross Profit .. After insertion Ex... 21 Jul 2008 18:13

More Efficient If Statement
I have the following code as part of a macro. Is there a more efficient (i.e. less code) way of writing this IF statement? Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Address = "$G$9" Or Target.Address = "$G$10" Or _ Target.Address = "$G$11" Or Target.Add... 21 Jul 2008 13:04

Conditional Formatting from VBA
I'm trying to set the Conditional formatting of a cell in Excel from Access - Don't ask ! The condition? I the characters 'KC' appear anywhere in C11, I need to set color to green. Anyway - the code :- Imagine that objSht is a Worksheet object that I am workingh on from Access .... With objSht .Ra... 21 Jul 2008 05:52

Procedure too large
Hi Group, I am getting a message, "Procedure too large", there is a limit on the amount of code that be be executed? This means I have to eliminate some of the code? Thanks, David ... 20 Jul 2008 16:35

Code Modifications
I use the code below to populate the Monthly Summary log using a combo box that the user selects a date. In my source sheet (Daily Reading Master Log) I have added a new row for column headings and removed column A. Problem: How do I adjust this code to account for the changes, so that code runs and the ... 20 Jul 2008 14:31

How do I make the mouse cursor get a value..?
Fellow programmers thank you for your time. I need some assistance... I am trying to figure out how to get the mouse cursor select from text from a specific x z cord and paste the value in a text box on my userform. Here is some code I tried... SetCursorPos 255, 413 Do Until UserForm1.TextBox1.Value = 521 DoE... 20 Jul 2008 20:41