Run Time Error '94' Invalid use of null

The error generally mean that you are trying to use an object / item which is not defined..


Might be you text box name is spelt differently and you are trying to call it by different spelling


If you can post the workbook , we can try to find the error

You are tring to load data from 90 cells into one label, most of which are empty so there is nothing to display.

Why are you doing this?

error is in this part of code

Please Login or Register  to view this content.

in the first line you have defined a range G10:G100... which will have 90 different values..

And in the below code u are calling that 90 values in one text box .. which is not possible...


try modifying the above code to
"G10:G10" " , "h10:h10" and "i10:i10"

Please Login or Register  to view this content.

Originally Posted by stoey

question to Shijesh,
will the values entered in any of those cells under the training,time and date be displayed still on the userform?

Hi stoey,

Values will still be displayed.

Hi

Test the attachement.

You need to explain how the program should know which date to display from column G.
Is it the first item in the list, excluding empty rows or maybe the last item in the list.

You could event loop though all the records and buiild a string containing all dates and show that but that would not appear to make sense.

Take some time to explain what you are trying to do rather than make us guess.