Search results

Hats off to you. I am impressed with your way of coding. I will check the file and update ASAP. Thanks again.

Appreciate you helping me. Thanks a ton again Please watch the video for error message https://vimeo.com/312742452

Thanks, You did an excellent job and sorted the issue, however, there are some more queries. 1)The List box displays the results well, however, the Top Row is blank, also I need data from column E to P in list box. 2)When I type the Initials of the name, List Box only displays The name and...

A Hope you are back, please assist.

Thanks for your help Let me give you an example User clicks on Instant Search and types ''s', at this time I want all employees name starting with S. Now if the user wants to get employees name starting with 'd', he will clear the text box and type d. At this time listbox should refresh and...

Dear Team, I have uploaded the file. User can select only 1 option, Either instant search or Select from list What i want is -- 1)when i click on Instant search and type employee name, i want data matching to be displayed from Data Sheet Column E to P in DataResult 2a)when i click on Select...

Sure, I am creating the file with dummy content and will share shortly

i tried to increase the count of list box, but how can i make it to display certain columns.example (F:J)

Team, Based on earlier suggestion, I have prepared the below code. I created a user form, image attached. Let me give you an insight into how it works for easy understanding. As you see the image, its optional for the user to select the dates. User has 2 options Select from List and Instant...

Also wanted to know, how will Kill variable delete the file. I mean can't we use any delete command

Appreciate your help. I checked it's creating a file tempo.jpg of approximately 3.8 MB(need to reduce that as well) But its not deleted the file and same images are send everytime. I deleted the file manually and ran the code and I was able to get correct report as an image. As a wordaround I...

It does not delete the file Checked the same in appdata folder

I have vba code to send excel range as an images using Ms outlook. The image is saved in User/Temp folder, but the image is not deleted after sending mail. if you see the last lines of the code, there is no code to delete the file. excel is not overwritting the image file, instead its sending...

Superb great. Is there any way to delete names range in 1 particular column(F) and then recreate it

Someone in the forum, helped me creating named ranges from pivot table, and then link it with comobox but I have some more issue Rebriefing some more issues Issue # 1 Post no 2 VBA gives an error as it tried to go beyond last Row of excel(A1048576), it creates name ranges, but gives an error...

This worked like a charm, howwver there is small issue here the example which i posted only had firstname. So i just added last name to some names, Refreshed Pivot and ran VBA for Comobox, but didnt workout Rebriefing some more issues Issue # 1 Post no 2 VBA gives an error as it tried to go...

If I share the file with other users, then I have to tell everyone to save the Macro. That doesn't seems to be a good option.

Great, but how via VBA However it would be better if its pasted in Outlook via Bitmap directly. Our organisation has blocked Paint

When I copy a table and a chart in excel and paste it as Bitmap in Ms outlook the image is crisp and clear. When I paste it as Windows Metafile, it's blurred and not crisp. If there any way, I can paste data as Bitmap in Outlook via Excel vba

I use to send email by using Excel vba late binding method Everything use to work fine, but now there is a new issue, when I try to send mail I get a message in ms outlook if I will like to allow a program to send email Options are Allow/Deny Earlier I wasnt getting this issue, might be some...

Don't want it as attachment. Please suggest how to proceed with IMG tag

Team, I have data in my sheet and want that data to be sent via email. I would prefer that data should be sent as an image, rather then text. I am using ms outlook 2007. Need VBA code for sending email as image.

Kutools has become quite famous now a days, it had many functionality that excel lacks. If I modify a file using Kutools and send it to someone will the other user be able to use it, who does not have Kutools

this was great buddy however the heading is missing I mean Emp Name/Manager also can i use one search box to search for Emp Name/Manager. I mean in search bar, if i type ABC, it will list all Employee and Manager name I also think that the Reset button is no more required

our users fills out a user form and click on save. The record is saved after the last row, on a different file in Shared drive. If 2 to 3 users save record at the same time, what are possibilities of error