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: 661
Default looking up data and using a combobox user form

Hello all, and thank you to those who have helped me in the past. This is a
great forum.

I am pulling my hair out. I have a worksheet with named ranges product
number, product name qty price. I need code that will allow me to make bulk
changes to data. Ideally I would like a combobox that will firsttly ask what
variable needs to be changed... ie price. the second combo box then opens and
askes the user to enter the product number or product name from a lthe named
range, and then allows the user to update the selected variable in this case
the new price. This new price is entered into the worksheet. It continues
until the user decides to quit or select another variable.

All help much appreciated.

 
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
User form ComboBox Items: Remember user entries? [email protected] Excel Programming 0 March 29th 07 06:41 PM
Adding to excel user form combobox Gimp Excel Programming 3 January 26th 07 05:02 PM
Could not set the Text property of a ComboBox on User Form. NickHK Excel Programming 2 December 13th 06 11:30 AM
Could not set the Text property of a ComboBox on User Form. John Bundy Excel Programming 0 December 11th 06 11:58 PM
User Form-error 1004 unless opened in sheet w/combobox data dpaulos[_2_] Excel Programming 2 January 27th 04 03:25 AM


All times are GMT +1. The time now is 06:42 AM.

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"