| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete an Item in a list box
Is it possible to select a line in a textbox and the delete it using vba. I
would like to simulate the user clicking a row in a textbox and then entering the delete key? The textbox is not on a 'form' but rather on the spreadsheet. Does it matter? The textbox was loaded using something like. If TextBox1.CanPaste = True Then TextBox1.WordWrap = False TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsBoth TextBox1.Text = "" TextBox1.Paste end if Thank you, Fred Jacobowitz |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete an Item in a list box
Sorry - Subject should read - Delete an Item in a text box
"Fred Jacobowitz" wrote in message ... Is it possible to select a line in a textbox and the delete it using vba. I would like to simulate the user clicking a row in a textbox and then entering the delete key? The textbox is not on a 'form' but rather on the spreadsheet. Does it matter? The textbox was loaded using something like. If TextBox1.CanPaste = True Then TextBox1.WordWrap = False TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsBoth TextBox1.Text = "" TextBox1.Paste end if Thank you, Fred Jacobowitz |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete an Item in a list box
Try looking at selection, or active selection,
textbox1.seltext.delete ? might work, be somthing like this there is also CurLine prop. might be able to do something with that. "Fred Jacobowitz" wrote in message ... Sorry - Subject should read - Delete an Item in a text box "Fred Jacobowitz" wrote in message ... Is it possible to select a line in a textbox and the delete it using vba. I would like to simulate the user clicking a row in a textbox and then entering the delete key? The textbox is not on a 'form' but rather on the spreadsheet. Does it matter? The textbox was loaded using something like. If TextBox1.CanPaste = True Then TextBox1.WordWrap = False TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsBoth TextBox1.Text = "" TextBox1.Paste end if Thank you, Fred Jacobowitz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to pair each item on one list to each item on another list | Excel Worksheet Functions | |||
| Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
| how to delete 1 item in colum | Excel Discussion (Misc queries) | |||
| How do I delete a character from a list of item numbers? | Excel Worksheet Functions | |||
| Selecting an Item from a List and getting a different item to pop. | Excel Worksheet Functions | |||
Linear Mode
