Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up boxes
Im trying to have an active cell referenced by a popup box when some
one clicks on a button, that will then index/match the reference cell to data base in a different workbookdb. Any help is greatly appreciated. Thanks for any help Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pop up boxes
Sub Button_click()
set rng = workbooks("OtherBook.xls").Worksheets("Sheet1") _ .Range("A1:Z200") res = Application.Match(activecell.Value,rng,2,False) if not iserror(res) then msgbox "Value is " & res else msgbox "Value not found" End if End Sub If you want index(match then provide the specifics. -- Regards, Tom Ogilvy mark long wrote in message om... Im trying to have an active cell referenced by a popup box when some one clicks on a button, that will then index/match the reference cell to data base in a different workbookdb. Any help is greatly appreciated. Thanks for any help Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Moving. Want to number boxes and inventory contents of boxes | Charts and Charting in Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |