LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to get the location of a Form Combo Box inside the assigned ma

I'm using Excel 2003 in Win XP

I've created several Combo Box controls (with the form toolbar) that trigger
macros to execute code that depends on the row where the control is.

The code only differs by the row number and I was looking for a way of
getting this information from Excel inside the triggered macro.

The only way I found so far is to create a separate macro for each Combo Box
named after the row on which it sits. This macro then calls the common code
passing it the row number.

I searched the Excel Application model to no avail.

Anybody know how to do this?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error using a combo box with an assigned macro in Excel EA Excel Worksheet Functions 2 October 2nd 07 04:08 PM
Error using a combo box with an assigned macro in Excel EA Excel Discussion (Misc queries) 0 October 1st 07 08:18 PM
Assigned macros change location markvi Excel Discussion (Misc queries) 3 April 6th 06 06:48 PM
Disappearance of assigned value of varaible when working with form vbaprog Excel Programming 7 January 19th 05 11:39 PM
Combo Box Inside a Form Joe B.[_3_] Excel Programming 1 November 12th 03 11:33 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"