Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm missing a line or something... it ends with the dollars option. Please help!
'Text Box, enter which month you want Aswr = Application.InputBox(prompt:="Choose one" _ & vbCrLf & "Hours" _ & vbCrLf & "Dollars", _ Title:="Do you want to enter FTE hours or dollars?", Default:="hours") 'Sets the correct value based on Aswr If Aswr = "Hours" Then Range("D" & CStr(LSearchRow)).Value = "00060" Range("E" & CStr(LSearchRow)).Value = "y" Range("D" & CStr(LSearchRow)).Value = "00060_SALARYBEN" If Aswr = "Dollars" Then Range("D" & CStr(LSearchRow)).Value = "00060" Range("E" & CStr(LSearchRow)).Value = "n" Range("D" & CStr(LSearchRow)).Value = "00060_SALARYBEN" If Aswr = False Then Exit Sub End If If RSort < "Hours" Then If RSort < "Dollars" Then End If End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Text on Option buttons | Excel Discussion (Misc queries) | |||
Add a text to rows option | Excel Worksheet Functions | |||
In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
Option Commands (Option Explicit / Option Base etc) - Scope | Excel Programming | |||
Option Compare Text | Excel Programming |