storing formula under a button

pao · Apr 18th, 2002, 02:11 PM

Can any tell me how to store a formula under a button or key??

Jack in the UK · Apr 18th, 2002, 03:38 PM

best to use VBA UDF abnd set to range to then carry out routeen ie formual else it will bounce out..

WARNING i love UDF but they are hard to work and painful to maintain, they really can slow a sheet to a crawl, i really LOOVE then what better that = JAcksCool or Jacksmagic to do that task but pitfulls are dreadful...

Button with one formula will bounce out as not very range aimed.. negative i know but true,

barrie Davidson and Dave hawley cover UDF on there site, as do posters on here but not what i call suceeded... worth a look though depebds on your VBA skills

Apr 18th, 2002, 03:38 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	best to use VBA UDF abnd set to range to then carry out routeen ie formual else it will bounce out.. WARNING i love UDF but they are hard to work and painful to maintain, they really can slow a sheet to a crawl, i really LOOVE then what better that = JAcksCool or Jacksmagic to do that task but pitfulls are dreadful... Button with one formula will bounce out as not very range aimed.. negative i know but true, barrie Davidson and Dave hawley cover UDF on there site, as do posters on here but not what i call suceeded... worth a look though depebds on your VBA skills __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 02:11 PM	#1
pao New Member Join Date: Apr 2002 Posts: 13	Can any tell me how to store a formula under a button or key??