Help with Case and Select case

brent chadwick · #1 10-05-2015, 06:48 AM

Thanks Paul, I have many questions, I will try to limit them.
1) Where does the dropdown menu come from?
2) What is Chr(148)?
3) What are Private Sub Documents?

Learning, lots more to learn-

brent chadwick · #2 10-05-2015, 08:23 AM

I'm working on my Mac and instead of the " after the dropdown menu (which I think is Chr(148)), I get a " î". What's up with this?

brent chadwick · #3 10-05-2015, 08:30 AM

Got it, it's an ascII character and for the Mac it's 211-learning new things-

macropod · #4 10-05-2015, 02:26 PM

Quote:

Originally Posted by brent chadwick

1) Where does the dropdown menu come from?
2) What is Chr(148)?
3) What are Private Sub Documents?

1: It's just an ordinary dropdown formfield that I added to the document. No code involved.
2: A closing double-quote character
3: There is no such code in the document I posted. Amongst other things, the 'Private' directive hides a Sub from the GUI

brent chadwick · #5 10-05-2015, 02:31 PM

1) What I want to know is how you did #1
2) Why not just insert text? Preference?
3) I have no clue what a GUI is-

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace & case	Jennifer Murphy	Word	1	02-11-2013 03:26 AM
Question about Case statement	Jennifer Murphy	Word VBA	1	01-05-2013 02:30 PM
Case Sensitive (contains) Selection	apolloman	Excel	2	07-12-2011 04:50 AM
From all UPPER CASE to Proper Case	davers	Word	1	04-30-2009 12:41 PM
Upper to lower case	jd	Excel	1	04-28-2006 07:40 AM