Add field based on excel data with keyboard shortcut

macropod · #1 01-11-2017, 09:42 PM

Try the attached template. Note that I've made some other changes to the code, too, so that it simply looks at the first worksheet in the workbook rather than looking for one named 'Folha1'.

Guimenez · #2 01-12-2017, 01:32 AM

Quote:

Originally Posted by macropod

Try the attached template. Note that I've made some other changes to the code, too, so that it simply looks at the first worksheet in the workbook rather than looking for one named 'Folha1'.

Hi, now it's more generic

But i'm getting the same error.
If i have names in the first columm and no number in the second columm, it stop the macro with an error.

I've attached my excel data for you try it out please.
thank you

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing keyboard layout - Changing/removing keyboard shortcut	Hans L	Windows	2	08-16-2015 05:33 PM
keyboard shortcut	ilor	OneNote	1	11-13-2014 02:48 PM
disable ctrl+space excel keyboard shortcut	melvinjn	Excel	2	11-27-2013 04:11 AM
Keyboard shortcut for bookmarks	Jennifer Murphy	Word VBA	1	01-06-2013 07:38 PM
Outlook Keyboard shortcut	sostrow28	Outlook	1	12-10-2010 05:57 AM