View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DaveyJones DaveyJones is offline
external usenet poster
 
Posts: 44
Default Userform, listbox and ActiveCell. I'm stumped

My project, after many weeks, is nearly finished. I have just got to input
some date values.

I am going to use a right click event to open a userform with a listbox then
the user can click on an entry in the listbox. Then the userform closes with
the value clicked on in the ActiveCell(or cell that was right clicked on to
open userform).

I have trawled through many online tutorials but non seem to deal with this
kind of problem. The data is todays date +- 5 working days In 'C!A10:A20'.
That I have dealt with. I just need to get the yuserform to work. Any help
would be greatly appreciated...


--
Dave