Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-28-2018, 03:18 AM
eduzs eduzs is offline Combobox to trigger sub only when item selected by click Windows 10 Combobox to trigger sub only when item selected by click Office 2010 32bit
Expert
Combobox to trigger sub only when item selected by click
 
Join Date: May 2017
Posts: 266
eduzs is on a distinguished road
Default Combobox to trigger sub only when item selected by click

I want my Combobox (userform) to trigger sub ONLY when the item selected by click, not when I type some text and this text corresponds to a value in the list.


Using click event: the problem is that when I type a text that corresponds to a item in the list and try to click in this item, this does not triggers any click event (click, mouseup, mousedown).
Using change event: when I type some text and this text corresponds to a item in the list it triggers the event, even when I was typing only to search items in the list.

Is there any solution for this?
Thank you
__________________
Backup your original file before doing any modification.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Powerpoint slide table data to combobox item janism22 PowerPoint 0 03-25-2015 05:05 AM
Need macro to fill data from different sheets based on selected item from drop down skorasika Excel Programming 1 03-13-2015 11:25 AM
Combobox to trigger sub only when item selected by click Start Animation with click on multiple trigger (after one another) KaySunset PowerPoint 5 02-26-2015 01:23 AM
Combobox to trigger sub only when item selected by click Selected items in Combobox remain the same when closing and reopen document Attila Word VBA 3 01-29-2015 04:08 AM
Returning a specific value when item is selected from a drop-down list J Press Excel 4 09-10-2012 06:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft