Posts by ExcelVBALearner

    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.


    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!