Search results

thanks a lot guys you amazing.... Nipen

Hi Experts, can we remove the specify name in cell value if I have to remove Nipendra here then? only by excel formula I wan to do it. raj,Npendra,kamal,raju Sam,Harish,Nipendra,Raj Praveen,Amar,Amit,Nipendra Kiran,Aman,Pari,Nipendra,Mukesh,Arjoo Regards Nipen

thanks folks

Hi Experts, can please someone help me out how I can add calendar on vba user form I have downloaded MSCAL.OCX ,mscomct2.ocx files and paste in to system 32 still cant able to see the Microsoft month view control 6.0(sp4) in additional control window please suggest me here. Regards Nipendra

Hi Experts, please suggest for protect the word document actually I am saving a word doc by excel vba code and want to protect it also but not idea how to do it Regards Nipen

Hi Experts, Actually I am working on a project where I am in between a query, Is this possible that we enter some input from vba form and input should be reflect on pdf and word page where I want ? Like I have four input box on the form 1- Name 2- Id 3- Process Name 4-...

Thanks for ur all feedback and comments here you go http://www.2shared.com/file/XRbnmDrs/Count_No_Of_QCd.html regards Nipendra

No dear actually this is not the Question the problem is I have three criteria 1-Month 2-Week 3-Name so ( A,b,c,d,e ) I have names here and I want count A(input),B(input),C(input),D(input),E(input)same for the rest names with month and week criteria I can do it easily with countifs but the...

Hi All, can we count the horizontally criteria in excel countifs. I have a Query Example- [ Name ] Month Week A B C D E Jan Week 1 Input 1 5 9 4 2 Feb Week 1 Output 5 8 9 5 7 March Week 1 WiP 6 2 4 3 4

thank u for you prompt response its working Thanks a loooootttttt Regards Nipendra

Hi Experts, can someone help me for below data--- Example-: Name--- A B C D E F Input 1 2 3 4 5 6 output 2 4 6 5 8 9 WIP 9 8 9 4 6 2 I want to calculate the value of A(Input)=?,A(Output)=?,A(WIP)=? Advanced Thanks Regards Nipen

Hi All, can we lock an object on the excel file Like -: if I have a object of word file in excel sheet then how can we lock it so that no body cant move it to another location Regards Nipendra

I am sorry Sir I am not getting you and you almost got my point I need to only--- when I will click on the save button it should be save in to our database table (which is working fine) as well as in to the listbox1(which is not adding right now) actually I never work with vba before first time...

I am so obliged for you time and comments and you almost got my point, I request you to please ignore the textbox name or whatever it is ..........leave by the default name. yes I knew it I can add the value by the click event with this code = ListBox1.AddItem "Nipendra" but I am saving my...

thanks for your valuable reply but can you download it, if yes then please suggest something I am so harass with it Regards Nipendra

Dear i don't want to sin up there so really not able to do it leave it I'll do it my self Thanks Nipendra

SP Hi Again, sorry for confusion here but i have attached the file please click on the "main form" button on sheet1 then it will show the main form but due to connection path it wouldn't be open there so please go through with code and my problem is that i am using access ado connection to...

Hi SP, my question is that how do I refresh the data after click on save button or whatever it is ,mean to say that when I click on the save or delete button the record is going to save or delete but it is not displaying after the click , when I reload the form then it is showing with the...

thanks debraj for response I got my solution Nipendra

I have a listbox with two column name and id question is how to display the values in the text box when I click on the record in listbox Nipendra

but how to upload it I don't know. Regards Nipendra

Hi all, i have a question here, i have two textbox the first is name and the second one is for id here i am using both for save record in access database and it is working successfully but i need to show the name and id in textbox as well when i click on the saved record let say example i...

Hi Everyone, Is there some dummy project where i can see some conectivity with access database and some advance used code which is used for corporate level work to help,where i can understand how to make advance vba project to automate most of thing.

sorry i di'nt get you i am using ADODB connection to link with access database and insert query is working fine and as of now i am giving manually input to id field Regards Nipendra

Hui thanks for forgive me, here every thing is clear i can easly save my data to access table which name is emaster by this same query string ""Sets abc = "insert into emaster(eid,ename) values(" & TextBox4.text & ",'" & TextBox3.text & "')"", but now i dont want to give input in id textbox...