$$Excel-Macros$$ popup comments using vlookup or lookup UDF IN VB
hi [U][SIZE=5]just want to have comments populate when the cell is selected based on the lookup/vlookup function through VB[/SIZE][/U] two sheet 1) master_sheet 2 )data sheet masters sheet being dynamic data sheet is static master sheet continuosly changing now when a particular cell is activated by using mouse or keyboard comments should pop-up getting the value from the next data sheet eg: master sheet , cell a2= 1 cell a3=2 cell a4=4 so on and so forth in data sheet , cell a2= 5 , cell b2= present a3=2, cell b3= absent a4= 3,cell b4= leave a5= 1, cell b5= left now when i select a3 cell in master_sheet i need to populate a comment as [B]absent[/B], when the cell a3 changes to value [B]1[/B] i should get a comment display of value [B]left[/B] also when the cell value changes it chsould clear the previous comment basically it should popup comments based on the value from the data sheet !:) attaching herewith the sample data for ur reference -- 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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Sample file.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ hi all
hi i have a value in sheet 1 named black and another sheet named white in Sheet named black in cell A1 i already have a value with validation on it In Sheet named white i have certain values in column A the values are from A1 to A10 Now i am want a vb code to check if i enter a value it has to cross check whether it is there in sheet named white in column A if it is there it should pop up a message please help on this -- 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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ use of excel sheet to limited time frame say month, day, time or limited number of days
hi all can anybody suggest a vb code or a macro to a excel file the moment it is opened it can check on the usage of the file or it can stop from further use until it is being given permission by the creator of the file basically it should not be copied and if copied from one computer to the other, it should have a restriction to limited time frame say month, day, time or limited number of days until the user contacts the creator of the file your sugesstion and feedback well apprecitated sample file can be sent if required Regards Sunil Lobo -- 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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ use of excel sheet to limited time frame say month, day, time or limited number of days
good:thanks its of great help On Sun, Jun 16, 2013 at 7:37 AM, De Premor wrote: > For do that, you need to know the unique value on each computer to > determine that the file was used on another computer. > Something that will unique on every computer is Hardisk SN > > Private Sub Workbook_Open() > Dim MySN, CurrentSN As String > MySN = "1409978829" 'Your Current Hardisk Serial Number > CurrentSN = > CreateObject("Scripting.**FileSystemObject").GetDrive(**Left(Application.Path, > 1) & ":\").SerialNumber > If MySN <> CurrentSN Then > MsgBox "Unautorized Access" > 'place your code to do next in here while unauthorized access > detected... > End If > End Sub > > > > Pada 16/06/2013 1:33, sunil lobo menulis: > > hi all >> can anybody suggest a vb code or a macro to a excel file the moment it is >> opened it can check on the usage of the file or it can stop from further >> use until it is being given permission by the creator of the file >> >> basically it should not be copied and if copied from one computer to the >> other, it should have a restriction to limited time frame say month, day, >> time or limited number of days >> until the user contacts the creator of the file >> >> your sugesstion and feedback well apprecitated sample file can be sent if >> required >> >> >> Regards >> Sunil Lobo >> -- >> 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<https://www.facebook.com/discussexcel> >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to >> excel-macros+unsubscribe@**googlegroups.com >> . >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at >> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> >> . >> For more options, visit >> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >> . >> >> >> > -- > 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<https://www.facebook.com/discussexcel> > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- You received this message because you are subscribed to the Google > Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to > excel-macros+unsubscribe@**googlegroups.com > . > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at > http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros> > . > For more options, visit > https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> > . > > > -- 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)
Re: $$Excel-Macros$$ Copy data from multiple sheets into single sheet.
there is a tool namely an addd-in called rdbmeger can be installed on to excel ,,, the benefits of this is that multiple sheet data with same column can be combined on to one single sheet plus different workbook sheet can also be combined on to one sinlge worksheet do a google if not get in touch can help out regards On Sat, Mar 29, 2014 at 10:41 PM, Satiqjaffar ali wrote: > thanks a lot Ravinder > > > On 27 March 2014 13:08, Ravinder wrote: > >> PFA >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Satiqjaffar ali >> *Sent:* Wednesday, March 26, 2014 11:47 PM >> *To:* excel-macros@googlegroups.com >> >> *Subject:* $$Excel-Macros$$ Copy data from multiple sheets into single >> sheet. >> >> >> >> Hello experts, >> >> >> >> Can any one explain the process that i subjected how to do in efficient >> way, which will help us to reduce our copying time. >> >> >> >> Requirements, >> >> >> >> 1) Need data from more than 200 worksheet into one sheet, >> >> 2) The combined data need in one format what i mentioned in sheet >> Requirement. >> >> >> >> Many thanks in advance. >> >> >> >> Regards >> >> Satiq >> >> Kuwait >> >> -- >> 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, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> >> -- >> 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, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > 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, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.
Re: $$Excel-Macros$$ Personal.xlsb
Goto excel press alt+f11 u can find the personal macro vb code there delete it and ur done On 9 Apr 2014 05:38, "who" wrote: > Hello, > > Good day to all. I have created by mistake personal.xlsb in Excel 7. I did > this when I was trying to save a file and picked xlsb by mistake. The file > name was not even PERSONAL, but was "Ch2". It was intended to be macro > enabled. > > All files are unhidden and I know the path where the file is supposed to > be, but I can not see the file at all. When I go into Excel 7 now this > PERSONAL.XLSB takes over. Any attempt to record a macro ends up in this > file. > > I went into dos and located the right directory and even found the file. I > deleted the file and dir no longer finds the file. But when I go into X7 > and record a macro the PERSONAL.XLSB takes over again. I have been trying > to kill it all day and can not seem to get it. > > Any ideas would be appreciated. Microsoft was not very helpful and wanted > to charge me $260 for their help. None of their directions on line worked. > > Thanks, > David > > -- > 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, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.