Recent Activities

  • Trutech

    Thread
    A control transformer is required to supply voltage to a load, which requires significantly higher current when initially energized than under normal steady state operating conditions. A control transformer is designed to provide secondary voltage…
  • hamptongolfer11

    Like (Post)
    Hi to all.
    hamptongolfer11, have a try with what I came up.
    I'm using function OnKeys to launch a macro to show the key pressed and add a Tab key. This macro is only for 0 to 9, nothing to do with Numeric keypad since they have a different coding and to…
  • Hello Experts,
    I am using two sheets, one for invoice generating and other for invoice data. I can copy Invoice data to sales sheet of selected items, how to copy invoice number with selected Items.
    If i select 3 items Invoice number copy 3 time, if i…
  • rollis13

    Replied to the thread Auto move to next cell.
    Post
    (Quote from hamptongolfer11)

    I think it will be useless if you have a Windows x64, the NumLock bug I indicated will 'get you trouble'.
    This is a long time issue so I don't understand why it never has been fixed. Don't Win x64 users use SendKeys anymore ?
  • Glad it worked for you.
  • hamptongolfer11

    Replied to the thread Auto move to next cell.
    Post
    Thanks Rollis for all your work. The example you attached works exactly as I want it to. I will have to try and find a work around to use the keypad. I am 5 times slower using the # keys than the keypad. Appreciate your effort.
  • hello :)

    I love learning vba there are so many ways to be creative...
    but one of the most annoying things is this: you succeeded in creating a good thing, so you start trying the next creation...
    and when that's done...? the creation before is not working…
  • rollis13

    Replied to the thread Auto move to next cell.
    Post
    Hi to all.
    hamptongolfer11, have a try with what I came up.
    I'm using function OnKeys to launch a macro to show the key pressed and add a Tab key. This macro is only for 0 to 9, nothing to do with Numeric keypad since they have a different coding and to…
  • hamptongolfer11

    Replied to the thread Auto move to next cell.
    Post
    (Quote from tr1face)

    This may work but I am not sure of the process to "split it up into single digits, listing them in desired rows". I am fairly new to macros.
  • Logit

    Post
    You are welcome.
  • tr1face

    Replied to the thread VBA help needed.
    Post
    Hey royUK, can you please take a look on this topic and advice if it's achievable? Thank you!!
  • tr1face

    Replied to the thread Auto move to next cell.
    Post
    Hey Hamp,

    Until you're pressing Enter you're still gonna be in Edit Mode, so I don't think it's possible.

    You could use another cell on your sheet to enter one long number which consists of all your data, then split it up into single digits, listing them…
  • KjBox

    Post
    Try yhis
    (Code, 8 lines)

  • maztek

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • hamptongolfer11

    Replied to the thread Auto move to next cell.
    Post
    (Quote from royUK)

    Thanks Roy, but that is what I am trying to avoid.
  • tr1face

    Replied to the thread VBA help needed.
    Post
    Found some useful code on GitHub, which was made Public and I am now closer than I was before.

    Below will extract the number of required rows (random) for each person, but there are numbers required for each process as described in "Parameters" tab. Can…
  • withflowers

    Wrote a comment on withflowers’s wall.
    Wall Comment
    With Flowers is Preserved Flowers Melbourne the one – stop destination for all your Flowers in Parkville, delivering a wide rangeRoyal Women’s Hospital Flowers of floral arraMelbourne flower needs. With Flowers is one of the most trusted Flower Delivery…
  • eppel1337

    Thread
    Hi. I'm trying to create a macro, that will add plus one to the previous number in the column. Specificaly column A. The only macro I have been able to find is plus one to the selected cell. Sub P1() For Each cell In Selection cell.Value = cell.Value +…
  • Hendrensylvia

    Wrote a comment on Jackdavis85’s wall.
    Wall Comment
    Assignment Help from GreatAssignmentHelper.com offer you flawless assignment compositions that assure best grades at very moderate and affordable rates. Our Assignment Help UAEhas been consistently offering precise and excellent Online Assignment Help
  • ansh2792

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid