Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread joseph camill
Hi Pramod, None are working. On Mon, Nov 3, 2014 at 7:18 AM, Pramod Singh pramod...@gmail.com wrote: User id is 123456 Password may be 321 or 123 or the Try in three password. . Regards Pramod Pramod On 3 Nov 2014 02:02, joseph camill joseph.cam...@gmail.com wrote: Hi, I do not

Re: $$Excel-Macros$$ Data Clean

2014-11-03 Thread Paul Schreiner
How do you want to do this? I simply highlighted the ū and hit ctrl-c then selected all cells and hit ctrl-h (to find/replace) in the find box, i hit ctrl-v to paste the ū in the replace with box, i inserted u and then hit ReplaceAll. it worked just fine. Paul

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread my excel
Guru Vaibhav Sir, is it possible to use this login form to excel add-in file using this authorized user can use (run) add-ins macro add-in name = ctools macro names= get SlNo, Top10, Reports etc Sir, pls send code for add in if login success than only add-in macros enable else disable thanks

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread Ashish Kumar
Hi, Try this UserName password. UserID - 123456 Password - secret Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread Pramod Singh
Hi All. User id 123456 Password: 321 REgards Pramod On Mon, Nov 3, 2014 at 6:48 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, Try this UserName password. UserID - 123456 Password - secret Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread joseph camill
Hi, I am not sure who this is myxlg...@gmail.com. Please use a different mail to solve your queries, as it may confuse me to look for an appropriate answer and ask question to the experts. On Sun, Nov 2, 2014 at 7:05 PM, my excel myxlg...@gmail.com wrote: Pramod is it possible to use this

$$Excel-Macros$$ Four options to every question need to be randomized

2014-11-03 Thread Rajnish Malhotra
In the attached excel file (version 2007), the first sheet is quiz and second sheet is sheet1. It has a question/answer sheet (sheet1) that is designed in such a way that the first letter of the question is prefixed with the answer. For example here is a sample data in the range A1:A20 which

$$Excel-Macros$$ My macro won't work in Excel 2013. Please help.

2014-11-03 Thread Daryl Zer0
Trying to filter a few numbers from a larger group of numbers in one cell, copy them, then paste them in another cell. Error comes up as Runtime error '1004': Paste special Method of Range class fail. When I go to debug, it shows this: [image: copy to clipboard] Sub Macro1() ' ' Macro1 Macro

$$Excel-Macros$$ Backup contact

2014-11-03 Thread Rahul Kumar
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Userform - Login

2014-11-03 Thread my excel
thanks for replying i named this mail id as myxlguru bcoz whatever i posted question in this group i got exact correct answer who send solution to me i called him as guru (master) vaibhav sir, ashish sir, paul sir etc all are masters master thanks On Mon, Nov 3, 2014 at 8:08 PM, joseph camill

$$Excel-Macros$$ Userform - Login Disable Add-ins

2014-11-03 Thread Vaibhav Joshi
myxlguru, Add new module in this macro with follo. code. Call this macro whenever there is unsuccessful event. Once macro is ready create add-in of macro file install it. So whenever is excel is loaded it will disable addins if unsucessfull login.. code: Sub Disable_Addin() Dim

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

2014-11-03 Thread Ashish Kumar
Hi Vaibhav Bhai, It's perfect. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ how to copy a text from a cell into several rows

2014-11-03 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Nov 4, 2014 at 11:56 AM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Vaibhav Bhai, It's perfect. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ My macro won't work in Excel 2013. Please help.

2014-11-03 Thread Vaibhav Joshi
Hi Use this code: Sub Macro1() If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData End If Range(F4:F16).ClearContents ActiveSheet.Range($A$1:$E$279).AutoFilter Field:=1, Criteria1:=RGB(255, _ 0, 0), Operator:=xlFilterCellColor a = Range(A Rows.Count).End(xlUp).Row Set Rng =