Thread: Type Mismatch error when trying to generically set ComboBox to aComboBox variable
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
  
Posts: 3,514
Default Type Mismatch error when trying to generically set ComboBox to a ComboBox variable
It happens that bllittle formulated :
Dim lngRecords, lngFields, lngRows, lngColumns As Long

Just so you know; In the line above the only variable that is type
declared as 'Long' is the last one. The first 3 become type 'Variant'
by default because you did not specify their type.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


Reply With QuoteReply With Quote