Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

Data Validation with Combo box autocomplete

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tamee - 07 Apr 2007 10:06 GMT
Hi! I am using data validation with combobox autocomplete and it's working
fine. However, I noticed I am unable to cut and paste values from other cells
(cells which do not have data validation) I'd like to know if there's any way
I can have the cut and paste function back? Thanks!
Debra Dalgleish - 07 Apr 2007 14:12 GMT
You can add a bit of code to test for CutCopyMode, and exit the
procedure if it's true:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str As String
Dim cboTemp As OLEObject
Dim ws As Worksheet
Set ws = ActiveSheet

Application.EnableEvents = False
Application.ScreenUpdating = False

If Application.CutCopyMode Then
  GoTo errHandler
End If

Set cboTemp = ws.OLEObjects("TempCombo")
  On Error Resume Next
  With cboTemp
    .Top = 10
    .Left = 10
    .Width = 0
    .ListFillRange = ""
    .LinkedCell = ""
    .Visible = False
    .Value = ""
  End With

errHandler:
  Application.ScreenUpdating = True
  Application.EnableEvents = True
  Exit Sub

End Sub

> Hi! I am using data validation with combobox autocomplete and it's working
> fine. However, I noticed I am unable to cut and paste values from other cells
> (cells which do not have data validation) I'd like to know if there's any way
> I can have the cut and paste function back? Thanks!

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

tamee - 11 Apr 2007 02:16 GMT
Hi Debra! Thanks for your reply. I tried the code below and it's not working.
I have a list of over a thousand entries of spare parts w/combobox
autocomplete working fine. However, after making the combobox work I am now
unable to cut/copy/ paste values from other cells (cells which do not have
combobox). Pls. help! thanks!

> You can add a bit of code to test for CutCopyMode, and exit the
> procedure if it's true:
[quoted text clipped - 35 lines]
> > (cells which do not have data validation) I'd like to know if there's any way
> > I can have the cut and paste function back? Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.