excel list box

steve5915

New Member
Joined
Feb 8, 2024
Messages
7
Office Version
  1. 2021
Platform
  1. Windows
Hi
Using controls in excel with very basic knowledge i have populated a list box by using the row source property and it populates fine
now i wish to select an item in that list box to open a text box but when i use if listbox1.listindex=0 (first item in list) then textbox1.visible-true it does nothing
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
It wouldn't be .visible minus true. It should be .visible = True
If that's not the issue because you are using = sign then copy/paste your actual code because writing it out in a post is not a good idea. If you post more than a line or two, please use code tags (use vba button located on posting toolbar) to maintain code indentation and readability.
 
Upvote 0
Solution
Glad I could help. Typically if someone gives you a solution you don't mark your own reply as the solution? :unsure: .
 
Upvote 0
Was that thanks always the typo
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.
 
Upvote 0

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top