Search results

@Anamika Please have a look http://answers.microsoft.com/en-us/office/forum/office_2007-excel/allow-multiple-users-to-access-and-fill-in-the/aba97e43-f2b0-47d6-84d6-10a948c4311a ND...

@Izu Welcome to the forum, glad you are here Please download the file again and Press the Alt + F11 there you will find a UserForm1 press the F5 button then change the text from the Combo List and see what happen. if any issue please come back again with full details actually what do you...

@Subageethan Sorry for my late replay just i was out way from this Forum for long time so i didn't check any posts here, i think your problem may solve if not then please re-post with new question @KapooK Can you elaborate us what do you mean may be some body help with your problem or me...

@Somendra Misra The Drop Down list is showing only for Text in the particular Columns and not for Dates and Amount too Thanks for your feedback Regards SP

Faseeh bhai kainse hain, bahut din ke baad me chandoo.org me access kiya hum bhai mera eak request hain oh kya hai ki mere liye ek Inventory UserForm banayenge kya o bhi 10 to 15 items with party name, bill no and date ke sath. mein bahut dhunda hain Google me magar result 0 aapka sahayata ke...

@James Perry if Possible please upload a sample file for better knowledge to the forum readers and Ninja's too Thanking You

Hello Sir, after long time i back to my home town and now i am in work. Sir sorry to send this private Msg, i have small doubt that is is it possible to use the Advance Filter option for Selection Columns to Extract in another Sheet with VBA if possible please give me some idea about that...

@uday sorry for my late replay, actually i am busy with my personal work please refer the link it will give you some idea for shrink http://www.andypope.info/vba/resizeform.htm and http://vba-corner.livejournal.com/1392.html Hope it clear other wise please inform Thanks SP

@Hussein already we told you to upload a sample file so Please upload with your exact requirement Thanks SP

@Rej as per my knowledge there is no option to turn off the R1C1 Style in VBA or VB so when ever we record a macro through record macro from excel file then it by default it's take the R1C1 Style but the formula is working as we desire. if you want to know the formula then select the Range A1...

@Sara please try the below code Option Explicit Sub CombineFiles() Dim Path As String Dim FileName As String Dim Wkb As Workbook Dim WS As Worksheet Application.EnableEvents = False Application.ScreenUpdating = False Path = "C:\Users\user\Desktop\Sara" 'Change as...

@Hussein Welcome To Chandoo.org Forum, Glad you are here before post a question please read the Forum Rules from here and always try to post a sample workbook with desire request http://chandoo.org/forum/forums/new-users-please-start-here.14/ now come to your point you want use the formula...

Glad Your Problem Solve

My Hearty Congrats Bro on your achieve of 2k Milestone Keep Running Cheers

@deb Thanks for your input, off course i know this but the OP has to understand how that will happen with out errors / Zero Values, other wise he stuck in there :eek::oops: ???? Thanks SP

@ajaar Welcome to Chandoo.org Forum, Glad You Are Here This Forum is 24 X 7 and here every member will try to learn and try to solve the problems if any problem the Forum has beautiful Excel Ninja's and they can help To understand better about This Forum then please check the below link...

@deb i need some information about your file that is when i follow the instruction by you then the blank columns are blank in the next column but when i try the same thing new file then i am getting Jan 1900 how it is happen did you give any other formats for that because when i try the same...

@uday add the below code into your UserForm Module Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function SetWindowLong Lib "user32" Alias "SetWindowLongA" (ByVal hwnd As Long, ByVal...

@Seahorse As per SirJB7 point out the result is coming 3 if we use the SirJB Formula If we use this then your required result is coming let's try =COUNTIFS($A$2:$A$8,"Refurb",$C$2:$C$8,"None",$B$2:$B$8,"<="&TODAY()) if any problem please inform Thanks SP

@uday another way just add the one more line in the commandbutton that is UserForm1.Show vbModeless we can do anything with excel file when the UserForm is Activate too Thanks SP

@Jeo In your Sheet1 Tab Column AZ is text format and you have to convert it as Number format so first select the AZ2:AZ17 and right click of mouse button and select the format cells then go to Custom and 000 digits in the Type when you enter in the Range AZ2:AZ17 = 1 / 2 then it will appear...

Narayan Sir My Hearty Congrats on Your 7k Milestone, please keep guiding us

@SANTHOSH Please Follow the Below Instruction : 1. Open your file 2. Press Alt +F11 3. In the Insert option select Module 4. Copy the Given Code and paste it 5. Close the VBA Project Window 6. Now press the Alt +F8 and run the code Hope it clear Thanks SP Note: Due to Net problem my...

@krispar Please Check this link may be it will help full http://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html if any issue then please inform us Thanks SP

@milankumarsahu Welcome to Chandoo.org Forum, Glad you are here as per Vijay said may be it is Pivot Table if it is not please upload a sample file Thanks SP