 |  |  |  |  |  |  |  |
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?
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?
•
•
•
•
Originally Posted by vbcielle 
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?
Last edited by cguan_77; Jan 30th, 2009 at 3:36 am.
|
Similar Threads
- Excel Question (Windows Software)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Text box differences
- Next Thread: VB hardware appli
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
