vb drop down menue

Giganews Newsgroups
Subject: vb drop down menue
Posted by:  conorot (conorot.27xzqm_1147853400.9238@excelforum-nospam.com)
Date: Wed, 17 May 2006

hi i have a problem trying to show data from a excel file up into a
dropdown menue in vb, the problem is that it works ok when the selected
woorksheet is selected in excel but when in another excel worksheet the
data does not show up in the dropdown menue.

sSheet = Application.ActiveSheet.Name
lCaseRow = ExcelRowExist(tb_Case.Value, sSheet)

cb_EscTeam.Value = Cells(lCaseRow, 14).Value

i think here where the problem is "ActiveSheet" i tried

ssheet="NameOfSheet"
lCaseRow = ExcelRowExist(tb_Case.Value, sSheet)

cb_EscTeam.Value = Cells(lCaseRow, 14).Value

but the same problem, any1 with any ideas?

--
conorot
------------------------------------------------------------------------
conorot's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34518
View this thread:http://www.excelforum.com/showthread.php?threadid=542810

Replies