Thread: Macro to choose data and export in another workbook
View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Ben McClave Ben McClave is offline
external usenet poster
  
Posts: 173
Default Macro to choose data and export in another workbook
Jerry,

See if this returns the expecting search value:

sFind = ThisWorkbook.Sheets("HOME").ComboBox1.SelText

Ben
Reply With QuoteReply With Quote