handle

  1. A

    VBA to backfill data in each row

    Looking for a piece of code that can dynamically backfill data as per image above. It should always fill back to column B and handle additional rows if new rows are added. Any suggestions appreciated.
  2. D

    Assigning an Array value from one worksheet to a cell in another worksheet

    I've spent some time searching on the internet how to handle this issue but I think I may be phrasing the questions or issue incorrectly and I have not been able to find any material on how to handle. So... here my simple problem: I have create an array (array_Chart10a) located in a worksheet...
  3. A

    Help with Last Column

    Hi, I have a form used for data entry, I would like to save the data from one of the text fields into Row 2 of the first empty column on another worksheet. I've got a handle of how to do this for a row, but I can't quite workout how to change it to suit a column. Hope you can help, thanks Adam
  4. C

    File Dialog - Button enabled if Item selected

    Hey guys In my code i use a folderpicker and a user can press on the OK-Button, even if he did not select any item. Does anyone know how i can handle this issue, like disable the button if not one item has been selected? Thanks in advance!!
  5. MacroAlan

    Changes from 2013 to 2016

    Just found out that one of our company's sites that I support got Access 2016 on new computer. Most of our apps are written in Access 2010 and separate versions are set to handle the Reference differences for 2013. Anything I need to know about 2016? Thanks,
  6. B

    Using Fill Handle to increase "time" formatted cells

    Working on a schedule where I want to increase each cell by :05 (five minutes) Cell A3 would have 4:05 Want cell A4 to have 4:10 A5 to have 4:15 and so on....possible using the fill handle? -------------------- Second option is I would use "two" times in one cell, like this: A3 4:05 - 4:10...
  7. V

    Double-clicking Fill Handle to copy cells loses undisplayed data

    If I enter a date and a time into a cell that is only displaying the date and use either Ctrl+C / Ctrl+V or drag the Fill Handle with the right-mouse button and then choose Copy Cells, the original cell is duplicated with the full date and time. However, if I highlight a copy of these cells and...
  8. B

    How do you get the IE object when you have the Window handle

    I'm trying to use Excel 2010 VBA to download tables from an Internet Explorer application. I've gotten to where the IE download manager pops up a window saying "Do you want to open or save xxxx from xxxx?" with the OPEN SAVE and CANCEL buttons. I haven't been able to get beyond this popup...
  9. P

    Getting the window title/caption from handle id

    I'm trying to find an answer to fetching the lpWindowName from a handle. I already have a way of finding the correct handle, and there's no problem finding an answer to that, but how do I get the window title from a handle i.e. 66340? FindWindow("SunAwtFrame", "(FTJ)") Gets the handle. Option...
  10. F

    Fill Down But Increment in Group

    I have items in a column like below: 50 50 50 50 What I would like to be able to do is highlight the four 50's and fill down, but I would like for it to increment and paste the next four filled like this: 51 51 51 51 Then below that the next four filled like this: 52 52 52 52 If its a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top