| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
left worksheet function within a combo box
I have created a combo box which contains a list of items. Once an item is
selected, Is there a way to limit the number of characters that appears in the combo box using the left worksheet function? -- Many Thanks, Paula |
|
#2
|
|||
|
|||
|
Hi
not really sure what you're trying to limit. Could you give an example (with cell references) -- Regards Frank Kabel Frankfurt, Germany "Billing Goddess" schrieb im Newsbeitrag ... I have created a combo box which contains a list of items. Once an item is selected, Is there a way to limit the number of characters that appears in the combo box using the left worksheet function? -- Many Thanks, Paula |
|
#3
|
|||
|
|||
|
Let's say for example, I have a list: aaaaa, bbbbb, ccccc, ddddd
I choose aaaaa from the dropdown. The customer needs to see the full character count when making the selection, but once it has bee selected, we would like the characters to be truncated to aa Does this make sense? "Frank Kabel" wrote: Hi not really sure what you're trying to limit. Could you give an example (with cell references) -- Regards Frank Kabel Frankfurt, Germany "Billing Goddess" schrieb im Newsbeitrag ... I have created a combo box which contains a list of items. Once an item is selected, Is there a way to limit the number of characters that appears in the combo box using the left worksheet function? -- Many Thanks, Paula |
|
#4
|
|||
|
|||
|
Hi
see: http://www.contextures.com/excelfiles.html and search for Data Validation "Columns" -- Regards Frank Kabel Frankfurt, Germany "Billing Goddess" schrieb im Newsbeitrag ... Let's say for example, I have a list: aaaaa, bbbbb, ccccc, ddddd I choose aaaaa from the dropdown. The customer needs to see the full character count when making the selection, but once it has bee selected, we would like the characters to be truncated to aa Does this make sense? "Frank Kabel" wrote: Hi not really sure what you're trying to limit. Could you give an example (with cell references) -- Regards Frank Kabel Frankfurt, Germany "Billing Goddess" schrieb im Newsbeitrag ... I have created a combo box which contains a list of items. Once an item is selected, Is there a way to limit the number of characters that appears in the combo box using the left worksheet function? -- Many Thanks, Paula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Executing macro for all worksheet from a different worksheet | New Users to Excel | |||
| move the worksheet tabs in a workbook to left | Excel Discussion (Misc queries) | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
| continuous cell function | Excel Worksheet Functions | |||
Linear Mode
