Insert Pictures Automatically Based On Cell Value
Pictures can be added in page quickly with VBA code .
According to the value entered in any cell of column A , the image is added automatically into Column E.
Images are resized to fit cells.
Updated Advanced Userform Example
I made some changes in the UserForm codes that I’ve done it before :
– Copying the filtered data into Page 2
– While entering data if there are duplicate values in a column ,can be warning with msgbox.
It’s other features :
– Data Adding
– Data Delition
– Data Update
– Searching with The Userform
– Progress Bar Feature
– Scrolling the Listbox with Spin Buttons
– Next ,Previous ,First ,Last Recording Buttons