Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page create a subroutine that allows the user to select the Identifier from a drop-down menu
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2023, 07:27 PM
Isi Isi is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2010
Novice
create a subroutine that allows the user to select the Identifier from a drop-down menu 		 
Join Date: Jan 2023
Posts: 4
Isi is on a distinguished road
Default create a subroutine that allows the user to select the Identifier from a drop-down menu
Please, how do I create a subroutine that allows the user to select the Identifier from a drop-down menu in cell F2 and the Key from a drop-down menu in cell F3 (these drop-down/data validation menus are already available in the starter file) and any rows of the data (columns A, B, and C) whose Batch ID meets those criteria will be highlighted GREEN.

Reply With Quote
  #2  
Old 01-15-2023, 01:06 AM
Guessed's Avatar
Guessed Guessed is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
Is this a Word or Excel question?

Post a sample file so we can see what you are trying to do.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 01-16-2023, 04:50 PM
Isi Isi is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2010
Novice
create a subroutine that allows the user to select the Identifier from a drop-down menu 		 
Join Date: Jan 2023
Posts: 4
Isi is on a distinguished road
Default
Reply With Quote
  #4  
Old 01-16-2023, 05:07 PM
Guessed's Avatar
Guessed Guessed is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,975
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
Isi
I'm not seeing any attachment or additional info in your second post.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 01-16-2023, 05:19 PM
Isi Isi is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2010
Novice
create a subroutine that allows the user to select the Identifier from a drop-down menu 		 
Join Date: Jan 2023
Posts: 4
Isi is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
Isi
I'm not seeing any attachment or additional info in your second post.
I am trying to add an image it seems not privileged to do so for now.
Reply With Quote
  #6  
Old 01-16-2023, 05:23 PM
Isi Isi is offline create a subroutine that allows the user to select the Identifier from a drop-down menu Windows 10 create a subroutine that allows the user to select the Identifier from a drop-down menu Office 2010
Novice
create a subroutine that allows the user to select the Identifier from a drop-down menu 		 
Join Date: Jan 2023
Posts: 4
Isi is on a distinguished road
Default
Quote:
Originally Posted by Guessed View Post
Is this a Word or Excel question?

Post a sample file so we can see what you are trying to do.
https://drive.google.com/file/d/1ju6zdST5kn-77FHXw6stJboGJK2Dfkwq/view?usp=drivesdk
Reply With Quote
Reply

Tags
vba

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a subroutine that allows the user to select the Identifier from a drop-down menu Cascading drop-downs in Word with one parent menu and four dependent drop-downs mrstrawhand Word VBA 3 03-30-2020 06:08 AM
Auto create new worksheet when select option from drop down list JANET JONG Excel Programming 1 08-01-2018 07:13 AM
Create a command button that will insert another drop down menu Tinamation Word VBA 1 11-06-2015 03:11 PM
Need help with drop-down menu please cazclocker Excel 7 01-05-2015 04:07 PM
Help, auto select drop down by another drop down value? skrallemand Word VBA 3 09-11-2013 11:55 AM

Other Forums: Access Forums

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

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft