Comments

1. Dan Brown says:

   2 February 2011 at 12:53 am

   Ross,

   I have developed a route handheld program for my ice cream distributing business using vba in excel and would like to add a signature capture function. Your code here looks like it would work for me or at least give me a good start. Would you sell this code to me to use?

   Thanks,
   Dan Brown

   Reply
2. ross says:

   2 February 2011 at 10:39 am

   Hi Dan,
   I can sell you the code if you like, but you can down load it for free! the link is at the bottom of the post! ;-)

   If you come up with anything that works I would be interested to see it, and maybe we could share it on the blog?

   Thanks
   Ross

   Reply
3. jecirbe says:

   8 March 2012 at 3:56 pm

   hello,
   i ‘m not an expert in vba. i want to know 2 things:
   first: is it possible to have the pen larger?
   second: is it posbble to save the drawing?

   thanks
   jecirbe from France

   Reply
4. Liviu S says:

   20 March 2012 at 11:57 pm

   Here is how you can get the color to work:
   for example edit the NewPen function as below:
   Sub NewPen(hWidth, hColor)
   hNewPen = CreatePen(PS_SOLID, hWidth, hColor)
   SelectObject hdc, hNewPen
   End Sub

   so just add SelectObject

   And btw, what is this Range(“repaint_mode”) = 0 ?
   and what is “repaint_mode”?
   I know what this line does but I can’t figure it out why…

   Reply
5. Henrik Stisen says:

   8 May 2012 at 10:50 pm

   If the code is Free why is there then password i Visual Basic?

   Reply
   • Camp David says:

     9 May 2012 at 6:06 am

     @Henrik, the password is right there on the front sheet, look again!!!!!

     Reply