Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Using XL2K, I have a Worksheet_Change event that accepts user input for 1 or 2 check amts. The user is then prompted for store name(s), Payee1 and *maybe* Payee2 via either 1 or 2 userforms. I need Payee1 and *maybe* Payee2 placed as a single line to the right of the check amt(s). Currently I use the following: Target.Offset(0, 1) = Payee1 + " " + Payee2 This way if there is only 1 payee, Payee2 won't appear. That's what I want, except instead of using spaces, I want Payee1 and Payee2 (if there is one) separated by a '/'. If there is only 1 payee, I don't want the '/' to appear. What code will accomplish what I want? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
putting a string from one cell in the formula of another -- indirect needed? | Excel Worksheet Functions | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
"Unable to Open File" - excel output of Datagrid <-help needed | Excel Programming | |||
Getting output from an excel output back to cscript.. | Excel Programming | |||
Create a formula into a String then assign string to a cell | Excel Programming |