| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple assignment question
I have a cell that is populated from a drop down list.
I want to place the value in the cell into a portion of memory and I cannot remember how to correctly word it. I have tried: myTitle = Range("B3").Value myTitle = B3 myTitle = Range("B3") myTitle = Worksheets("Current").Range("B3").value And all of the above combinations with Set in front. What am I doing wrong? I know this is something simple and I should see it but just am not seeing it. LWhite |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Simple assignment question
If it is from a drop down list then you need to refer to the control
containing the value. mytitle = combobox1.value -- Cheers Nigel "L.White" wrote in message ... I have a cell that is populated from a drop down list. I want to place the value in the cell into a portion of memory and I cannot remember how to correctly word it. I have tried: myTitle = Range("B3").Value myTitle = B3 myTitle = Range("B3") myTitle = Worksheets("Current").Range("B3").value And all of the above combinations with Set in front. What am I doing wrong? I know this is something simple and I should see it but just am not seeing it. LWhite |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Simple assignment question
Never mind. I found it. This should not be Long but should be String.
Sorry to bother everyone. LWhite |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pls answer the following question for me for my assignment. | Excel Discussion (Misc queries) | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple question | Charts and Charting in Excel | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| simple question, hopefully a simple answer! | Excel Programming | |||
Linear Mode
