Hi,
I just tried some kind of Add-in (VBA Code, free test version) that provides some help when writing code (I would use less than 5% of it, and the way to start a class in really great by the way).
The only feature I love and would like to do on my own is the possibility to add what they call a fragment, a piece of code I often use.
For example,
Through a menu in a VBA toolbar, I can access this fragment very easily.
Is there a way to build such bar/menu on my own? I would save it on onedrive to be accessible on different computers.
I guess it is not easy, but if you could give me some guidance on the steps/language (?) to take to build a toolbar in VBA that could paste pieces of codes (maybe textfiles saved on onedrive), that would be really great. Tanks in advance
I just tried some kind of Add-in (VBA Code, free test version) that provides some help when writing code (I would use less than 5% of it, and the way to start a class in really great by the way).
The only feature I love and would like to do on my own is the possibility to add what they call a fragment, a piece of code I often use.
For example,
Code:
'Last Row
Dim sh as workseet
Dim lr as long
lr=sh.cells(sh.[LEFT][COLOR=#3D3D3D][FONT="Courier New"]Rows.Count, "A").End(xlUp).Row[/FONT][/COLOR][/LEFT]
Is there a way to build such bar/menu on my own? I would save it on onedrive to be accessible on different computers.
I guess it is not easy, but if you could give me some guidance on the steps/language (?) to take to build a toolbar in VBA that could paste pieces of codes (maybe textfiles saved on onedrive), that would be really great. Tanks in advance