LITTLEBLACKDOG.COM Forum Index LITTLEBLACKDOG.COM

 
LWD LWD   FAQ FAQ   Memberlist Memberlist   Usergroups Usergroups   Active Topics Active Topics   Register Register  
  Profile Profile   Log in to check your private messages Log in to check your private messages   Log in Log in  
  Who is Online Who is Online   Image Gallery Image Gallery   Chat Chat   Search Search  
  LWDGear       LBDGear  

Excel VB Help!
 View next topic
View previous topic
Post new topic     Reply to topic   LITTLEBLACKDOG.COM Forum Index » General Software
Author Message
krunch34
Toilet Drinker
Toilet Drinker


Joined: 24 Oct 2000
Posts: 300
Location: USA
Post Posted: Tue Jul 17, 2001 3:36 pm   Post subject: Reply with quote Back to top  
I'm trying to make a combo/list box for my excel worksheet...but i can't get it to put any data in there... its not the same as the regular vb stuff for some reason. can anyone help??

_________________
-= k34 =-

"Relax...You'll Live Longer!"
View user's profile Send private message Send e-mail
PLD
Butt Sniffer
Butt Sniffer


Joined: 14 Mar 2001
Posts: 1726
Location: I Don't Remember
Post Posted: Thu Jul 19, 2001 3:15 pm   Post subject: Reply with quote Back to top  
Quote:

I'm trying to make a combo/list box for my excel worksheet...but i can't get it to put any data in there... its not the same as the regular vb stuff for some reason. can anyone help??




I may be able to send you the routines but you'll have to wait until Monday when I get back to work. I pretty sure I wrote something like that.

PLD

Cave' Caneum!

_________________
PLD
"I wonder what goes through his mind when he sees us peeing in his water bowl." -Penny Ward Moser paw5
"Two things are infinate, the universe and human stupidity. And I'm not sure about the universe." - Albert Einstein
View user's profile Send private message Send e-mail
PLD
Butt Sniffer
Butt Sniffer


Joined: 14 Mar 2001
Posts: 1726
Location: I Don't Remember
Post Posted: Thu Jul 19, 2001 3:22 pm   Post subject: Reply with quote Back to top  
Are you using 97 or Later?

If so, there should be a built in control for making drop down boxes. But I believe to populate the control I think it has to address a named range. In other words, put what you want in a column and the name that range of cells.

Cave' Caneum!

_________________
PLD
"I wonder what goes through his mind when he sees us peeing in his water bowl." -Penny Ward Moser paw5
"Two things are infinate, the universe and human stupidity. And I'm not sure about the universe." - Albert Einstein
View user's profile Send private message Send e-mail
krunch34
Toilet Drinker
Toilet Drinker


Joined: 24 Oct 2000
Posts: 300
Location: USA
Post Posted: Thu Jul 19, 2001 7:15 pm   Post subject: Reply with quote Back to top  
This is intended for Microsoft Excel 97

_________________
-= k34 =-

"Relax...You'll Live Longer!"
View user's profile Send private message Send e-mail
PLD
Butt Sniffer
Butt Sniffer


Joined: 14 Mar 2001
Posts: 1726
Location: I Don't Remember
Post Posted: Mon Jul 23, 2001 5:07 am   Post subject: Reply with quote Back to top  
I am sending you via e-mail a xls file that has VB to utilize a drop-down box. You should be able to pick it apart. and change as necessary to do what you want to do.

PLD

Cave' Caneum!

_________________
PLD
"I wonder what goes through his mind when he sees us peeing in his water bowl." -Penny Ward Moser paw5
"Two things are infinate, the universe and human stupidity. And I'm not sure about the universe." - Albert Einstein
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic     Reply to topic   LITTLEBLACKDOG.COM Forum Index » General Software
 
Jump to:  

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
phpBB SEO
All times are GMT - 8 Hours

Help us keep advertisements off this site. Donate today!