Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data from a listbox to a textbox
I am using a userform where I have listboxes just for displaying data that
was previously entered through a textbox. I have been entering dates, and now find that I also need to enter times. I have dates in the listboxes which I would love to be able to copy/paste (using cntl-c and cntl-v) to the text box so that I could just add a space and then the time (different times so a global search/replace option wouldn't work.) I have tried selecting the data in the listbox and doing cntl-c and going to the textbox and hitting cntl-v, but the data is not pasted. I know I can paste to the textbox as I went to a different application, copied some data and succesfully pasted. I looked through the different properties for the listbox, and searched through help, but I did not see an option that would allow a copy to work. Does anyone know a way of making the copy/paste work? Thanks. -- Kevin Vaughn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data from a listbox to a textbox
I guess I should have mentioned that I actually have 24 listboxes that could
have multiple lines of data (seperated by char(13), and I would want to be able to just select one line from any of those listboxes. I would think that if there is a solution for one listbox, I would be able to apply that solution to all of the listboxes. Not that I think this would matter, but it is actually a multipage form (with 3 pages) and 24 listboxes on each. -- Kevin Vaughn "Kevin Vaughn" wrote: I am using a userform where I have listboxes just for displaying data that was previously entered through a textbox. I have been entering dates, and now find that I also need to enter times. I have dates in the listboxes which I would love to be able to copy/paste (using cntl-c and cntl-v) to the text box so that I could just add a space and then the time (different times so a global search/replace option wouldn't work.) I have tried selecting the data in the listbox and doing cntl-c and going to the textbox and hitting cntl-v, but the data is not pasted. I know I can paste to the textbox as I went to a different application, copied some data and succesfully pasted. I looked through the different properties for the listbox, and searched through help, but I did not see an option that would allow a copy to work. Does anyone know a way of making the copy/paste work? Thanks. -- Kevin Vaughn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data from a listbox to a textbox
argh. That should be char(10) (just in case it matters.)
-- Kevin Vaughn "Kevin Vaughn" wrote: I guess I should have mentioned that I actually have 24 listboxes that could have multiple lines of data (seperated by char(13), and I would want to be able to just select one line from any of those listboxes. I would think that if there is a solution for one listbox, I would be able to apply that solution to all of the listboxes. Not that I think this would matter, but it is actually a multipage form (with 3 pages) and 24 listboxes on each. -- Kevin Vaughn "Kevin Vaughn" wrote: I am using a userform where I have listboxes just for displaying data that was previously entered through a textbox. I have been entering dates, and now find that I also need to enter times. I have dates in the listboxes which I would love to be able to copy/paste (using cntl-c and cntl-v) to the text box so that I could just add a space and then the time (different times so a global search/replace option wouldn't work.) I have tried selecting the data in the listbox and doing cntl-c and going to the textbox and hitting cntl-v, but the data is not pasted. I know I can paste to the textbox as I went to a different application, copied some data and succesfully pasted. I looked through the different properties for the listbox, and searched through help, but I did not see an option that would allow a copy to work. Does anyone know a way of making the copy/paste work? Thanks. -- Kevin Vaughn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox copying not like windows copying, heh? | Excel Programming | |||
textbox value copying | Excel Programming | |||
Populating TextBox Value--using ListBox | Excel Programming | |||
Copying TEXT from Textbox to other location | Excel Programming | |||
Copying contents of a listbox | Excel Programming |