View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Profairy[_9_] Profairy[_9_] is offline
external usenet poster
 
Posts: 1
Default clear form combo boxes problem

Hi Tom,

Could you give me a quick example of how what to put in my new sub t
set all cbo boxes to -1

so far i've done

dim cbo as Combobox

For Each cbo in Userform2
if cbo.value = 0 then
cbo.value = -1
end if

Next

end sub

this doesn't work... i'm just guessing really as i'm still very new t
excel vba.

Thanks
helen x
;

--
Message posted from http://www.ExcelForum.com