| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display value in excel from module
Hi:
How would I display the value of OpCount in S5? ElseIf ActiveCell.Value = "OP" Then OPCount = OPCount + 1 from my module into my existing workbook cell s4? I've looked around & can't seem to find the solution & I know it's got to be easy... Thanks.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value in excel from module
Range("S5") = OPCount
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "mniccole" wrote in message oups.com... Hi: How would I display the value of OpCount in S5? ElseIf ActiveCell.Value = "OP" Then OPCount = OPCount + 1 from my module into my existing workbook cell s4? I've looked around & can't seem to find the solution & I know it's got to be easy... Thanks.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value in excel from module
Sheet1.Range("S5") = OPcount
Change the sheet number to suit, Regards, Alan. "mniccole" wrote in message oups.com... Hi: How would I display the value of OpCount in S5? ElseIf ActiveCell.Value = "OP" Then OPCount = OPCount + 1 from my module into my existing workbook cell s4? I've looked around & can't seem to find the solution & I know it's got to be easy... Thanks.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value in excel from module
Thansk So much...Works perfect.
Have a great day.... Alan wrote: Sheet1.Range("S5") = OPcount Change the sheet number to suit, Regards, Alan. "mniccole" wrote in message oups.com... Hi: How would I display the value of OpCount in S5? ElseIf ActiveCell.Value = "OP" Then OPCount = OPCount + 1 from my module into my existing workbook cell s4? I've looked around & can't seem to find the solution & I know it's got to be easy... Thanks.... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display value in excel from module
sheets("sheet1").range("a1")=opcount
-- Don Guillett SalesAid Software "mniccole" wrote in message oups.com... Hi: How would I display the value of OpCount in S5? ElseIf ActiveCell.Value = "OP" Then OPCount = OPCount + 1 from my module into my existing workbook cell s4? I've looked around & can't seem to find the solution & I know it's got to be easy... Thanks.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Linear Mode
