$$Excel-Macros$$ cursor control

I have an unusual situation, but the bottom line is a am looking to have more control over the cursor. I have a vba UserForm and am trying to track mouse movement. When i move the mouse 1 inch in the X direction, I want the cursor to move 0.25 inches on the UserForm. Is that possible? I have b

$$Excel-Macros$$ Re: [5]

What kinda buttock name ya got there WillieWanker? On Monday, December 15, 2014 6:56:40 AM UTC-5, black panther wrote: > > Click here to see this full message >

$$Excel-Macros$$ Need help

afford to sort my self out of this predicament, I will pay back as soon as I return. Western Union transfer or MoneyGram is the best option to send money to me. Let me know if i should send my details(Full names/location) to make the transfer, thanks. I await your response. Best Regards, Philip

$$Excel-Macros$$ Vba function in which a value is looked up in referenced range from a formula result

Consider the Function I created below (to generate task dates of a project schedule) and its procedure equivalent after that. The Test procedure works perfectly, because the lookup function for PrecDate is able to return the date value. But the lookup function for PrecDate in the STARTDATE functi

$$Excel-Macros$$ excel vba code to change hyperlink default file path

When inserting a hyperlink the dialog box uses the path of the active workbook. I need code to change the hyperlink path to a sub folder and then insert a hyperlink with Application.Dialogs(xlDialogInsertHyperlink).Show, with that subfolder active. -- -

Re: $$Excel-Macros$$ Dynamic criterion range for Advanced filtering

I sent an attachment. Any help? Philip On Feb 2, 6:42 am, "C.G.Kumar" wrote: > Could you please attach an excel worksheet for the problem you are facing. > > Regards, > > C.G.Kumar > > > > -Original Message- > From: excel-macros@googlegroups.c

$$Excel-Macros$$ Dynamic criterion range for Advanced filtering

To automatically track the criterion range area for advanced filtering when adding a value on the next row in the criterion range (so that I can filter Value A OR Value B), I want to make the criterion range dynamic. However, when repeating the Advanced filter command after inputting Value B on th

$$Excel-Macros$$ Dataform applied to a database not starting in Row 1

I have two databases in a worksheet, the second's headers are on Row 40. On highlighting the second's headers and data, the Dataform correctly picks up the related fields. However, when running VBA code, the dataform defaults to the fields of the first database in Row 1. A workaround this proble

$$Excel-Macros$$ Where did the data analysis tool pack go in the new version?

We just converted to the new version of Excel. I used to use a couple of functions from the data analysis toolpack (regression & histograms). Can anyone tell me how to get at that functionality from "the ribbon"? --~--~-~--~~~---~--~~