Search results

Thanks a lot

HI DEAR somendra i did not understand!!! is there any way or not? if it is possible , please meke a sample file and upload here for me and other friends to learn it. thanks a lot thanks a lot

Hi Dear Professors; Is Thare any way to make a picture as a watermark background in a listbox in a userform ? such as put the logo of a company as a background in a list box in a user form ? i am a beginner in excel and vb . if you can please help me with a sample file. thanks a lot .

Dear sir Hui; thanks a lot from your help . Thanks a lot i upload my file here for you. when i change drop down list my data in list box will change i want a macro on this user form for print just data in the list box . if there is any way when i print , i want borders between data and bold...

Hi Dear Professors, i have a listbox(listbox1) in a userform(userform1) in my workbook . i want a command button in my userform to print( print preview)data that shows in listbox1 . can you please help me with a sample file ? i am a beginner in vb and can not use only codes . i need a sample...

Thanks alot thank you so much dear friends thank you

Hi Dear Professors i explain i have a workbook . i made a combobox in a worksheet. in this combobox i have the name of some worksheets . i want a code for : when i select a data from combobox i can touch a shape to go to that page.

Hi Dear Professors i need a macro for assign to a shape that when user run this code , user go to page that named in cell g1 in sheet H . that cell ( cell G1 in sheet H) connect to a combobox . there for i want when use that combobox with a shape near it i can go to that page .(in combo box...

Hi Dear Friends Dear Professors Is There any way that we can use dynamic pictures in mail merging? For Example, I have a workbook that Contains personal Data. I want To mail merge pictures of persons . there is not important for me that the pictures be in that workbook or in a folder in my pc ...

Hi Dear Friends Dear Professors Is There any way that we can use dynamic pictures in mail merging? For Example, I have a workbook that Contains personal Data. I want To mail merge pictures of persons . there is not important for me that the pictures be in that workbook or in a folder in my...

Hi Dear Professors ; I have a excel sheet that in every row are sale of companies. in every columns are month names. then in every cell we have the sale of a month of a company! I want in every column know that how many companies make approximately 80% of sale of that month.

Hi, Dear friens. My name is Hooman. i am from iran. i am a beginner in excel and vb.i use excel from 2008 and now i think i am a beginner in excel when i see your posts,your questions,and your gide,and your attached files. i signed up in this site from 2010 but my id was lost.that name was...

Thanks Dear Faseeh, Thanks a lot for you reply i am not a beginner user in this site and i am here for about 3 years . but i forced to change my username because mu id was damaged. how ever thanks alot for your guide. please help me for this article that i named up.(Circular Graph) Can you give...

i forget that i want make it for my Country Calendar.(Persian Calendar In Iran)

Hi Dear Professors; Yesterday I saw a picture that shows a circular Calendar that i attached it Here. is there any way to make this calendar with graphs in excel just like that picture(very cute and cool)??? if it can;please help me . . . . Best Regards.

Hi Dear Friends, I have a vb that will send active workbook such an attachment with outlook. that is it : ---------------------------------------------------------------------------------- Sub EmailFile() Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set...

hi Dear professors; i have a workbook that there are some sheets in there these sheets are different conditions some of them are visible some of them are hidden and some are very hidden i want a macro that when user click on a button to run this macro; that user see a user form that contains a...

Hi Dear Professors; I want a Macro For Merge Cellsthat select with mouse drag with a short key(e.g Ctrl+Q),That they Are In A Column(Such as column A) these cells just countains data in first cell. for example i want to merge cells A5:A12 with Short Key (Ctrl + Q) that just there is one data in...

I Do Puzzles

hi dear professors; i have a vb code in my file that when a user click on a shape that code runs. i need a vb code or a formula that when that user click on that shape and run that code , input current date in a cell and input current time in an other cell . please help me!!! Thanks a lot

Hi,Dear Professors! i need a macro code i have a file with several sheets i list several of these sheets in a list(in column(A) in a sheet that named("Menu") i want to delete just sheets that they named in that list in column A in sheet("menu") perhaps there is a name in the list(in column(A))...

hi dear friend that is YYYY/MM/DD

hi dear friend, can you please help me to make a template that for example in column A , they can not enter any data without ( YYYY/MM/DD ) Format? please make it for me and upload any where for me to download it.Please. Thanks alot

Hi Dear Friends i have an excel files.there are in column D , Date Data.(ie, 2014/12/01 or 2013/02/04 or ...)there are more than 4000 Rows. that data comes from more than 20 excel files from several cities. members who send these files to me are idiot and they can not sen that data...

hi m hi my dear friend your file is good and thank you for your help. but i want a short key (e.g Ctrl+Q) for do this job. please if you want help me....