Need assistance with my macro form

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
More detail please....
Is it in a sheet module ?
Are there hidden module ?
Is it a user form?
Have Rclicked on the form and selected "View Code" ?
 
Upvote 0
Its in a sheet module.
There are no hidden modules
IT is a user form
Yes, i clicked on the form but unable to view code.
 
Upvote 0
Is the workbook Protected ??
in the VBA Project Explorer, there should be the workbook you are working with, then a couple of Sub menus for This workbook, Modules & Forms.
Can you double click on Forms ??
 
Upvote 0
It cannot be a sheet Module and a Userform

Are you sure you know what a UserForm is?

Try right clicking on your sheet tab and choose View Code
 
Upvote 0
It cannot be a sheet Module and a Userform

Are you sure you know what a UserForm is?

Try right clicking on your sheet tab and choose View Code


I cannot see any objects in the object browser. Do i need to code every object in the macro. I cannot see the object properties dialog.
 
Upvote 0
upload
Need assistance completing this macro . Thank you. I need to draw reports into the picklist from another worksheet and display reports on screen.
 
Upvote 0
Need assistance completing this macro

I'msure you do, but what you are telling us doesn't make any sense....how about uploading the workbook to DropBox and posting a link back here, so we can take a look ??
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,244
Members
452,622
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top