Inserting a Image Into Excel Userform and then edit -
i have able add/select image , load userform. wondering if there away load toolbox label(etc) userform when load image userform, have option edit image on userform.
thanks in advance
this code using upload image userform
with application.filedialog(msofiledialogfilepicker) .allowmultiselect = false .buttonname = "submit" .title = "select image file" .filters.add "image", "*.gif; *.jpg; *.jpeg", 1 if .show = -1 ' file has been selected ' e.g. show path in textbox me.textbox1.text = .selecteditems(1) ' e.g. display preview image in image control me.image1.picturesizemode = fmpicturesizemodezoom me.image1.picture = loadpicture(.selecteditems(1)) else ' user aborted dialog end if end
Comments
Post a Comment