Can anyone tell me why this code will not work. It is suppose to put the
value of TextBox1.Value and TextBox2.Value in one cell with a comma in
between.



ActiveSheet.range("44").Value = TextBox1.Value & ", " & TextBox2.Value

what is ActiveSheet.range("44")?

you need to specify a column foe the cell.

--

Gary


"Patrick C. Simonds" <(E-Mail Removed)> wrote in message
news:%23yZoo%(E-Mail Removed)...
> Can anyone tell me why this code will not work. It is suppose to put the
> value of TextBox1.Value and TextBox2.Value in one cell with a comma in
> between.
>
>
>
> ActiveSheet.range("44").Value = TextBox1.Value & ", " & TextBox2.Value

Sorry to waste everyone's time with that one. That 44 should have been A4.
Time to set this aside for the night.


"Gary Keramidas" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> what is ActiveSheet.range("44")?
>
> you need to specify a column foe the cell.
>
> --
>
> Gary
>
>
> "Patrick C. Simonds" <(E-Mail Removed)> wrote in message
> news:%23yZoo%(E-Mail Removed)...
>> Can anyone tell me why this code will not work. It is suppose to put the
>> value of TextBox1.Value and TextBox2.Value in one cell with a comma in
>> between.
>>
>>
>>
>> ActiveSheet.range("44").Value = TextBox1.Value & ", " & TextBox2.Value
>