Recent Activities

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…

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…

(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.

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…

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…

(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.

You are welcome.

Hey royUK, can you please take a look on this topic and advice if it's achievable? Thank you!!

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…

Try yhis
(Code, 8 lines)

Reached 1 year of membership at OzGrid

(Quote from royUK)

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

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…

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…

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 +…

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…

Reached 1 year of membership at OzGrid