Paste into spreadsheet in userform

S

Strobo

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!!!
 
S

Simon Lloyd

Do you have your userform modeless?


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)
 
S

Strobo

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 said:
Do you have your userform modeless?


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/showthread.php?t=181613

Microsoft Office Help

.
 
S

Strobo

Anybody?

Strobo said:
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 said:
Do you have your userform modeless?


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/showthread.php?t=181613

Microsoft Office Help

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top