feathers212
04-12-2007, 11:24 AM
I have a form, AddLineItem, with multiple text and combo boxes. When the Log_Waste button is clicked, the information from these boxes get entered into their appropriate cells on the sheet. There are two boxes on my form (Line_Item is a combobox and Item_Comment is a textbox) that get entered into a single spreadsheet cell with ": " between them.
Range("H" & RowNum).Value = Line_Item.Value & ": " & Item_Comment.Value
Later, a user can double-click on the row to edit it. I want the information from that row to be populated back into the form. My problem is I'm not sure how to split apart the information in the column H cell into it's two components on the AddLineItem form.
Any thoughts?
Range("H" & RowNum).Value = Line_Item.Value & ": " & Item_Comment.Value
Later, a user can double-click on the row to edit it. I want the information from that row to be populated back into the form. My problem is I'm not sure how to split apart the information in the column H cell into it's two components on the AddLineItem form.
Any thoughts?