Cell Formatting in Userform Data Entry Loops

  • Hello,


    Newbie here. I have a quick question about formatting cells after a value has been applied to a cell.


    Here is a sample code of what my userform looks like:




    After each value is inserted to a cell, I need the text to be indent twice, make the cell row height larger, format the text a certain font and color, and other particular formatting.


    I'm not sure how I can do this because there is a loop and the books I have don't cover this.


    Any help is appreciated, thanks!

  • Re: Cell Formatting in Userform Data Entry Loops


    Hi ExcelVBALearner,
    Welcome to the forum
    with out the workbook try..

  • Re: Cell Formatting in Userform Data Entry Loops


    Quote from pike;769903

    Hi ExcelVBALearner,
    Welcome to the forum
    with out the workbook try..


    irow = .Cells(Rows.Count, 5).End(xlUp).Offset(1, 0)


    Thanks for help! I tried the code, but this line come back with an Run-time error '91': error. Object variable or With block variable not set.

Participate now!

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