Cell to Textbox copy

  • I have the following formula in VBA

    Code
    textbox0.Value = Cells(Rows.Count, "C").End(xlUp)
    textbox1.Value = Cells(Rows.Count, "D").End(xlUp)


    I have log list of data in coloumn C and D.
    In textbox0 the data is being displayed but in textbox1 nothing is displayed eventhough I have data mentioned in coloumn D

  • Re: Cell to Textbox copy


    Code
    textbox0.Value = Cells(Rows.Count, "C").End(xlUp).text
    textbox1.Value = Cells(Rows.Count, "D").End(xlUp).text
  • Re: Cell to Textbox copy


    Quote from patel;647813
    Code
    textbox0.Value = Cells(Rows.Count, "C").End(xlUp).text
    textbox1.Value = Cells(Rows.Count, "D").End(xlUp).text


    Sir same thing is happening no data is displayed in textbox1, but data as appearing in textbox0

  • Re: Cell to Textbox copy


    Quote from jindon;647888

    No, I meant to say

    Code
    textbox0.Value = Cells(Rows.Count, "C").End(xlUp) 
    textbox1.Value = Cells(Rows.Count, "C").End(xlUp)(1,2)


    Thanks, working perfectly fine.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!