Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into spreadsheet in userform
Hi,
I have a userform on which is put a single column spreadsheet which I use as an input for my queries whose results are displayed in the form. Reason for that is that I often have a set of input values in a column so I want to be able to past the whole thing into my userform spreadsheet and as I scroll through them the userform is updated correspondingly. Now, everything works spot on, except for one thing. I am unable to paste into this spreadsheet. whenever I copy a set of cells on another worksheet and I switch back to the userform and try to paste, paste option is grayed out. I can type values into it, but I am unable to paste. Any ideas? Im using Excel 2003. Thanks!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into spreadsheet in userform
Do you have your userform modeless? Strobo;651108 Wrote: Hi, I have a userform on which is put a single column spreadsheet which I use as an input for my queries whose results are displayed in the form. Reason for that is that I often have a set of input values in a column so I want to be able to past the whole thing into my userform spreadsheet and as I scroll through them the userform is updated correspondingly. Now, everything works spot on, except for one thing. I am unable to paste into this spreadsheet. whenever I copy a set of cells on another worksheet and I switch back to the userform and try to paste, paste option is grayed out. I can type values into it, but I am unable to paste. Any ideas? Im using Excel 2003. Thanks!!! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181613 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into spreadsheet in userform
Hi Simon,
Yes, I have the userform modeless. I just tried without it and its the same. Furthermore, I just noticed that I can in fact paste free text into a single cell, but I am unable to copy cells from another worksheet, even if its only a signle cell. "Simon Lloyd" wrote: Do you have your userform modeless? Strobo;651108 Wrote: Hi, I have a userform on which is put a single column spreadsheet which I use as an input for my queries whose results are displayed in the form. Reason for that is that I often have a set of input values in a column so I want to be able to past the whole thing into my userform spreadsheet and as I scroll through them the userform is updated correspondingly. Now, everything works spot on, except for one thing. I am unable to paste into this spreadsheet. whenever I copy a set of cells on another worksheet and I switch back to the userform and try to paste, paste option is grayed out. I can type values into it, but I am unable to paste. Any ideas? Im using Excel 2003. Thanks!!! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181613 Microsoft Office Help . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste into spreadsheet in userform
Anybody?
"Strobo" wrote: Hi Simon, Yes, I have the userform modeless. I just tried without it and its the same. Furthermore, I just noticed that I can in fact paste free text into a single cell, but I am unable to copy cells from another worksheet, even if its only a signle cell. "Simon Lloyd" wrote: Do you have your userform modeless? Strobo;651108 Wrote: Hi, I have a userform on which is put a single column spreadsheet which I use as an input for my queries whose results are displayed in the form. Reason for that is that I often have a set of input values in a column so I want to be able to past the whole thing into my userform spreadsheet and as I scroll through them the userform is updated correspondingly. Now, everything works spot on, except for one thing. I am unable to paste into this spreadsheet. whenever I copy a set of cells on another worksheet and I switch back to the userform and try to paste, paste option is grayed out. I can type values into it, but I am unable to paste. Any ideas? Im using Excel 2003. Thanks!!! -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=181613 Microsoft Office Help . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste data from a workbook on a userform spreadsheet | Excel Programming | |||
Paste text to userform | Excel Programming | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Cut and Paste Wide Spreadsheet in Powerpoint, spreadsheet gets cut off | Excel Programming | |||
copy-paste in a userform | Excel Programming |