thanks Mate really nice solution.
regards,
Pawel
________________________________
From: Bé Trần Văn <betnmtdongna...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Monday, August 26, 2013 2:49 PM
Subject: Re: $$Excel-Macros$$ Re: listbox issue
You reference List Box in User Form follows:
- To enter data into the spreadsheet, click on the list box to get the data
into the appropriate form, edit the content and press Enter to edit data.
- To edit data, click on the list box to be modified to take the form data,
edit the content and press the edit button to edit the data.
- Do not click in the blank area below the list Box, because there is no data
in the Form Load will fail, press the End button to exit the error.
2013/8/26 pawel lupinski <lupins...@yahoo.com>
Hi All,
>
>unfortunately workbook is too big to share, but I've done some something
>(below):
> ActiveSheet.Shapes.Range(Array("ListBox2")).Visible = msoFalse
> ActiveSheet.Shapes.Range(Array("ListBox2")).Visible = msoTrue
>
>this is working, but still not perfect.
>problem is that something (macros) switching off/hiding listbox.
>
>Thanks for support
>
>Pawel
>
>From: Prince <prince141...@gmail.com>
>To: excel-macros@googlegroups.com
>Cc: pawel lupinski <lupins...@yahoo.com>
>Sent: Monday, August 26, 2013 8:05 AM
>Subject: Re: listbox issue
>
>
>
>Hi Pawel,
>
>
>Pls shere your workbook.
>
>
>Regards
>Prince
>
>On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote:
>Hi All,
>>
>>I have quite serious problem with the list box (ActiveX). when I use it on
>>the sheet where is placed is fine, but when I run any macro that is going to
>>different sheets suddenly is becoming disable. in order to activate it I need
>>to switch design mode click on list box and switch off design mode again. its
>>extremely irritating do you know what I need to do to be able use it without
>>such combination.
>>
>>Regards,
>>
>>Pawel
>
>
>--
>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 mailto:excel-macros%2bunsubscr...@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.
>
--
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.
--
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.
