kelbellene

The first thing I tried was taking out the CLOSING stuff. I had copied and pasted that out of the old spreadsheet I'm attempting to recreate. Even without that it generates the same error. It does it here as well: Private Sub ComboBox3_Change() If Range("L1").Value > 4 Then ComboBox5.Enabled = False ComboBox5.Value = 1 Else ComboBox5.Enabled = True End If End Sub For that it highlights "ComboBox5.Enabled = True".

Finally figured out. I can write If Then statements like a pro now.

Okay, I'm brand new to Visual Basic. When I close the spreadsheet I'm working on I get an Object Required error, which takes me to this: Private Sub ComboBox2_Change() If Not Closing Then If Range("O1").Value = 1 Then ComboBox6.Enabled = True ComboBox1.Enabled = True Else ComboBox6.Enabled = False ComboBox6.Value = 1 ComboBox1.Enabled = False ComboBox1.Value = 2 End If End If End Sub It points specifically to "ComboBox6.Enabled = False". That is the correct object name. What am I doing wrong? Thanks!

I have four lines of text that may or may not be populated based on some drop down menus in sheet 1 of this workbook. When the lines are populated they also populate in sheet 2, which is a form letter. How can I set up the letter so, say, if only lines 1 and 4 are chosen, there is no space between them in the form letter. Would this be a formula or a macro? I absolutley can't wrap my head around this. It's been a long day. Thanks in advance for any assistance!

I have an employee who types out a weekly task list which just shifts a day every week. She is hoping to be able to "roll" the list to the next week which would bump Friday's tasks to Monday and fill in the rest. Is this possible in Excel? It would be just as good if she could type in Monday's tasks and it would auto-fill the tasks for the rest of the week in the correct order. More of a visual explanation: Week #1: a b c d e Week #2: e a b c d Week #3: d e a b c

I have a user who is having trouble dragging and dropping email messages from her Inbox to other folders. She is able to move messages between any other folders besides the Inbox and can right click and use the "Move to Folder..." option. I restarted to see if that would help, but it didn't. Does anyone have any friendly suggestions? It is Outlook 2003.