| vbcielle | Jan 3rd, 2009 8:21 pm | |
| dropdown VBA excel
hello i am doing a program that saves cell values from sheet1 to sheet2 as my database including the value in the drop down.
my program can save the value of the dropdonw to sheet2 ...my problem is how can display return or display any values saved in sheet2 to the dropdown in sheet1 ?
is it like this?
sows.shape("drop down").oleformat.object.text=des.cell(srange & x).value
it displays/return the value but the problem is if i change the value in the dropdown it is not changing...can you help me? |
| cguan_77 | Jan 30th, 2009 3:34 am | |
| Re: dropdown VBA excel
1 Attachment(s) Quote:
Originally Posted by vbcielle (Post 770264) hello i am doing a program that saves cell values from sheet1 to sheet2 as my database including the value in the drop down.
my program can save the value of the dropdonw to sheet2 ...my problem is how can display return or display any values saved in sheet2 to the dropdown in sheet1 ?
is it like this?
sows.shape("drop down").oleformat.object.text=des.cell(srange & x).value
it displays/return the value but the problem is if i change the value in the dropdown it is not changing...can you help me?
| hi vbcielle, check the attached file and the simple macro program.. don't know if that's the one you're looking for.. but whatever dropdown list change in sheet2 is reflected in dropdownlist in sheet1.. :) |
| All times are GMT -4. The time now is 3:22 am. | |
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC
