Hi all,
I have created a list box (xactive control) with macro shown below:
To complete the list box, when click "AAA" shows 1, click "BBB" shows 2 and click "CCC" shows 3.
Please Login or Register to view this content.
I have searched for two days online that the solution is to add index formula to Linked Cell. However I can not use the index formula since my List Fill Range is in macro.
Any help would be appreciated.
Last edited by arlu1201; 02-28-2013 at 09:56 AM.
Re: List box's macro: Adding index formula to Linked Cell
Hi
Maybe this will help
Thanks Sniper.
Do you think you can make A8 to show 1 instead of AAA?
You mean like this?
This is wonderful. If you don't mind, one more request. Can the data be inserted into the macro instead having it on the Excel?
It can yes, does this mean that the data in the listbox never changes?
Currently that is the full list. The reason for this is to prevent accidental change unless you really want to change it.
In that case your original code is 100%
Please Login or Register to view this content.
Is it possible to transfer my data to your macro? I would like to keep it in one place.
DavidRoger,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes you can just add it here
I was looking for how to add the solve. Thanks for your guide. Thanks.Originally Posted by arlu1201
Good to know that you are helping really a lot. More than thanks. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks