Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-17-2008, 11:37 PM
Novice
 
Join Date: Dec 2008
Posts: 1
shashijb is on a distinguished road
Default List option

Hi i have query pls help me solve the problem,

1) Need to add one drop down list box with two items "YES" & "NO" in excel file.

2) If "YES" is selected need to display extra five fields (or rows) else it should not shouldn't show those extra five fields.


Thanks in Adavance ,
Shashi JB

Reply With Quote
  #2  
Old 12-18-2008, 03:07 AM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default

Hi shashijb, there is no other way to do this except for VBA programming. If you would like some assistance you will need to be able to use the forms toolbar and be able to copy and paste some code into the Visual Basic editor. I will also need to know the name of the worksheet and the row numbers you want to show/hide.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i take my contact list to a new computer? blade Outlook 2 01-13-2011 07:03 AM
Which app to use for list on Outlook? sus Misc 0 08-26-2008 08:46 AM
creating a categories list owwiii Outlook 0 08-09-2007 01:56 PM
Needs option to delete foward only when deleting reoccurring Peter Grono Outlook 1 02-19-2006 04:22 PM
Creating a Map From a List of Addresses aleccamp Excel 0 11-19-2005 03:04 PM


All times are GMT -7. The time now is 07:57 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft