Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 list of names and calling
Hi,
I'm using Excel 2003, i have a list of people names (First name A1:A100, Surename B1:B100, from C1:C10 are shown numbers) Also i have installed dialing program "ClickToDial", which start calling to certaing person if i'm marking number and push Ctrl + c c I want to do this way, that i can create in D1 search box, where i can put name to search, and in F1 cell i want to see search results, if i will click on to result i want that ClickToDial program will start calling. Is it possible to program this? Unfortunately i don't know exel very well, may ne someone can advice or show how is possible to do this little programming? Thank you for answear! Peeter Tiidemann |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 list of names and calling
1) why don't you use an autofilter?
2) you can use the sheet's 'double click' event...so hen one double click's a cell, it fires the code. the code can test the cell and then call the account To do this right click on the sheet's TAB and select 'View Code' from the popup menu, and add this code: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 3 And Target.Value < "" Then Cancel = True call "<dialer" End If End Sub the Target.CVolumn tests that the cell selectected is in column C. The <"" just makes sure that the cell isn't empty So if we want to make a call, then turn off the right click menu by settign cancel = TRUE and call the appropriate riutine. You can probably find this easily enough by turning on the macro recorder and dialling a number....see what gets recorded ...unless you already know the function that gets called...whatever it is replace my CALL DIALER with the correct function "Lion2004" wrote: Hi, I'm using Excel 2003, i have a list of people names (First name A1:A100, Surename B1:B100, from C1:C10 are shown numbers) Also i have installed dialing program "ClickToDial", which start calling to certaing person if i'm marking number and push Ctrl + c c I want to do this way, that i can create in D1 search box, where i can put name to search, and in F1 cell i want to see search results, if i will click on to result i want that ClickToDial program will start calling. Is it possible to program this? Unfortunately i don't know exel very well, may ne someone can advice or show how is possible to do this little programming? Thank you for answear! Peeter Tiidemann |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 list of names and calling
Thank you, but it is hard to do for me, i tried to create autofilter, but i
cannot search inside list. Also i tried to put this code into sheet and got error while inserting CALL DIALER, i don't know which function i have to use. It is just reads the clipboard if i push on keyboard Ctrl cc. May be you can send me demo file to my email or desribe this process step by step? I don't know very mutch excel to create this codes and filters. "Patrick Molloy" wrote: 1) why don't you use an autofilter? 2) you can use the sheet's 'double click' event...so hen one double click's a cell, it fires the code. the code can test the cell and then call the account To do this right click on the sheet's TAB and select 'View Code' from the popup menu, and add this code: Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Column = 3 And Target.Value < "" Then Cancel = True call "<dialer" End If End Sub the Target.CVolumn tests that the cell selectected is in column C. The <"" just makes sure that the cell isn't empty So if we want to make a call, then turn off the right click menu by settign cancel = TRUE and call the appropriate riutine. You can probably find this easily enough by turning on the macro recorder and dialling a number....see what gets recorded ...unless you already know the function that gets called...whatever it is replace my CALL DIALER with the correct function "Lion2004" wrote: Hi, I'm using Excel 2003, i have a list of people names (First name A1:A100, Surename B1:B100, from C1:C10 are shown numbers) Also i have installed dialing program "ClickToDial", which start calling to certaing person if i'm marking number and push Ctrl + c c I want to do this way, that i can create in D1 search box, where i can put name to search, and in F1 cell i want to see search results, if i will click on to result i want that ClickToDial program will start calling. Is it possible to program this? Unfortunately i don't know exel very well, may ne someone can advice or show how is possible to do this little programming? Thank you for answear! Peeter Tiidemann |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 list of names and calling
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 VBA calling VB.NET ? | Excel Programming | |||
create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
Can I check names in one list agains names in another in excel? | Excel Discussion (Misc queries) | |||
Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Calling Solver from an Excel 2003 Macro | Excel Programming |