Create Command Button to Copy Cell Value and Open a URL

I need to create a button that will do the following, depending on a simple formula:
A. if FALSE: Copy the value of a cell to the clipboard
B. if TRUE: Copy the value of a cell to the clipboard AND open a URL in the default browser window

This will need to work on Excel on a PC or Mac

I was able to copy to clipboard using this VBA:
Sub RectangleRoundedCorners2_Click()
Range("C16:D16").Copy
End Sub

Please help!

A. if FALSE: Copy the value of a cell to the clipboard

curious to know why copy the data to memory, if you're not going to do anything with it?

B. if TRUE: Copy the value of a cell to the clipboard AND open a URL in the default browser window

Are you planning to have a URL link within a cell, then use a button to execute a hyperlink?

Please clarify

If the formula is false, the user is copying the value to clipboard to paste it into another application

If the formula is true, the user is copy the value to clipboard to paste it into the webpage I am hoping to direct them to with the URL

I am trying to make it as automated as possible to reduce if not eliminate user error

I have a followup to my earlier question if anyone can help me out.

Similar worksheet, but the requirements have changed a little bit.

I have a worksheet with data input by another user in to 3 designated cells. In a 4th cell, I am using a simple concatenation formula to build a URL.

Once that data is input, I want the user to push a command button that will:
1. Copy the URL from the 4th cell
2. Go to that website
3. Return the data from that website and paste it in a 5th cell

Any ideas on how this might be possible? I think there is a similar function in Google sheets call IMPORTDATA.