Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data | Validation with VBA
Hello All,
I have created a dropdown list in my excel worksheet. I want to use VBA to change value(s) of the dropdown list in oreder to build automated function for my project. I don't know how to start. Please give me suggestion. March |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data | Validation with VBA
If you are using Data validation, the value is in the cell so you can just
overwrite it Range("B1").value = "the value" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "March" wrote in message ... Hello All, I have created a dropdown list in my excel worksheet. I want to use VBA to change value(s) of the dropdown list in oreder to build automated function for my project. I don't know how to start. Please give me suggestion. March |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data | Validation with VBA
let me tell you more info
I try this one thisWorkbooks.Worksheets("analysis").Range("G31"). Value = iCell iCells is a value that I get from another worksheet in the same workbook. When run the program, it says "Object required (Err 424)" It still does not work. March "Bob Phillips" wrote: If you are using Data validation, the value is in the cell so you can just overwrite it Range("B1").value = "the value" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "March" wrote in message ... Hello All, I have created a dropdown list in my excel worksheet. I want to use VBA to change value(s) of the dropdown list in oreder to build automated function for my project. I don't know how to start. Please give me suggestion. March |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data | Validation with VBA
That's ok. I've another solution. Thanks
"Bob Phillips" wrote: If you are using Data validation, the value is in the cell so you can just overwrite it Range("B1").value = "the value" -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "March" wrote in message ... Hello All, I have created a dropdown list in my excel worksheet. I want to use VBA to change value(s) of the dropdown list in oreder to build automated function for my project. I don't know how to start. Please give me suggestion. March |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |