About Us

trangnguyen

Quote:

Originally Posted by Claus Busch

Hi,

Am Wed, 12 Mar 2014 00:38:15 +0000 schrieb trangnguyen:

1 Megan Davis Convention Center p49 fig 2
2 Daily Meeting Room Rates
3 Code Meeting Room Advance Rate Standard Rate Special Rate
4 AU Auditorium $2,418.75 $2,925.00
$1,735.00
5 BD Boardroom $1,912.50 $2,550.00
$1,330.00
6 CF Conference Center $2,475.00 $3,200.00 $1,900.00

I would try it with dependent data validation.
Have a look:
https://onedrive.live.com/?cid=9378A...121822A3%21326
for the workbook "RoomRates"

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thanks you so much for spending time to help me. It works perfectly!

Claus Busch

Hi,

Am Wed, 12 Mar 2014 18:59:41 +0000 schrieb trangnguyen:

Thanks you so much for spending time to help me. It works perfectly!

always glad to help.
Please have another look in OneDrive. I improved the table a little bit.

Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

trangnguyen

Quote:

Originally Posted by trangnguyen

Thanks you so much for spending time to help me. It works perfectly!

I have another question if you dont mind to answer. Is it different if I use the combo box under formal control and to use Vlookup and nestif to write the formula. I dont want to use VBA

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting Combo boxes to change options based on other Combo boxes.	Ancient Wolf	New Users to Excel	1	March 27th 09 06:29 PM
Combo Box Values Not Sticking & Mult/ Combo Boxes in a WorkSheet	questor	Excel Programming	0	September 15th 08 01:38 AM
Selecting subsets using combo boxes or list boxes	CLamar	Excel Discussion (Misc queries)	0	June 1st 06 07:43 PM
Filtered list for Combo Box ListFillRange - Nested Combo Boxes	DoctorG	Excel Programming	3	February 23rd 06 12:15 PM
Using Combo boxes in excel	Kevin Smith[_3_]	Excel Programming	0	August 28th 03 10:49 AM

Menu

About Us