hi
i am not sure if this can be done or how,i have a textbox on a search userform ,at the minute i enter 2 in the box and press search button and it populates all textboxes and a listbox,is there a way to have a macro automatically enter a 2 in the box and automatically click the search button ,
this would then automate the process
cheers colin
Bookmarks