| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Darn function in vba
Not sure why this is proving to me so hard, what is wrong with this
wks.Cells(iRow, 4).Value = "= S & cboStallion)" cboStallion is my combo box, i want it to fill in the database looking something like: S6 -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Darn function in vba
Assuming the combobox is userform based:
wks.Cells(iRow, 4).Value = "S" & cboStallion.Value The main problem was that Excel thinks an entry preceeded with an equals sign (=) is a formula. It therefore calculates it which raises an error. You should also have excluded the combo's value from the quotations when concatenating. Inclusion of the leading equals sign when adding text to a cell is for intentionally adding a formula. I don't know what the single right parentheses was for. Typo I assume. Regards, Greg "Jennifer" wrote: Not sure why this is proving to me so hard, what is wrong with this wks.Cells(iRow, 4).Value = "= S & cboStallion)" cboStallion is my combo box, i want it to fill in the database looking something like: S6 -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Darn function in vba
Thank you much!
-- Though daily learning, I LOVE EXCEL! Jennifer "Greg Wilson" wrote: Assuming the combobox is userform based: wks.Cells(iRow, 4).Value = "S" & cboStallion.Value The main problem was that Excel thinks an entry preceeded with an equals sign (=) is a formula. It therefore calculates it which raises an error. You should also have excluded the combo's value from the quotations when concatenating. Inclusion of the leading equals sign when adding text to a cell is for intentionally adding a formula. I don't know what the single right parentheses was for. Typo I assume. Regards, Greg "Jennifer" wrote: Not sure why this is proving to me so hard, what is wrong with this wks.Cells(iRow, 4).Value = "= S & cboStallion)" cboStallion is my combo box, i want it to fill in the database looking something like: S6 -- Though daily learning, I LOVE EXCEL! Jennifer |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Darn function in vba
Thanks for the thanks. I appreciate the feedback.
Greg "Jennifer" wrote: Thank you much! -- Though daily learning, I LOVE EXCEL! Jennifer "Greg Wilson" wrote: Assuming the combobox is userform based: wks.Cells(iRow, 4).Value = "S" & cboStallion.Value The main problem was that Excel thinks an entry preceeded with an equals sign (=) is a formula. It therefore calculates it which raises an error. You should also have excluded the combo's value from the quotations when concatenating. Inclusion of the leading equals sign when adding text to a cell is for intentionally adding a formula. I don't know what the single right parentheses was for. Typo I assume. Regards, Greg "Jennifer" wrote: Not sure why this is proving to me so hard, what is wrong with this wks.Cells(iRow, 4).Value = "= S & cboStallion)" cboStallion is my combo box, i want it to fill in the database looking something like: S6 -- Though daily learning, I LOVE EXCEL! Jennifer |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| New workbook and darn text boxes | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
