Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 2nd, 2004, 05:02 PM
Registered User
 
Join Date: Mar 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default ComboBox Click even firing when opening workbook

I have two ComboBoxes each being loaded(ListFillRange) by spearate information in named ranges(ex. "benny" referes to i.e. c1:c25 loades Combobox1, etc.) on the excel sheet. This populates the box and allows the user to click on the item within the ComboBox. This item is associated with the click event which when selected opens the workbook associated with this item. My problem is that whenever the user selects a file,the associated workbook is opened, but this causes my sub to restart from the beginning. Which is not too bad since it basically tries to open the file again. However, it then jumps to the second combobox click even. The user hasn't done anything and I can't figure out why it is jumping from one sub to another when nothing has changed. any insight?






Similar Threads
Thread Thread Starter Forum Replies Last Post
DataList Command event not firing on first click nikkk ASP.NET 3.5 Basics 0 September 2nd, 2008 04:15 AM
on opening workbook, how to disable macro ? jjk2 Beginning VB 6 1 January 7th, 2008 05:05 AM
Right-Click or Double-Click Combobox? panuvin C# 2005 3 June 15th, 2006 04:30 PM
Opening an Excel workbook i n append mode Sumanths_query Excel VBA 4 May 13th, 2004 09:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.